Get instant live Excel expert help with Time and Date Functions
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
need to solve a multicriteria problem a little complex trying to do that from several days.
Solved by I. D. in 17 mins
I need to fix a formula that will be able to calculate the days of the reservations instead of the check-out
Solved by I. J. in 16 mins
Hello!
i need my template to fixed, i was trying to do something and i messed it up i dont know how it was made and deleted a formula which was linked to multiple cells please make my template working again its been days i am trying this but logic i cant understand.
Solved by V. H. in 22 mins
I need to sum amounts using sumifs for a range of days
Solved by I. F. in 28 mins
In cell K6, enter a formula to determine the total cost of the rental based on the daily rate, the number of days rented, the cost of gas, and any discount given to the customer. Note that the discount applies only to the car rental, not the cost of gas. Copy the formula to the range K7:K32.
Solved by F. B. in 17 mins
I need help setting up a macro that drags a formula down but then goes up to a set of cells and copies just the text/numbers above it and removes the formula. The reason for this is I am pulling data from a sql table that only has 4 days worth of data so as the form gets older the info in the old cells just shows Value or N/A
Solved by D. H. in 23 mins
hello,
I need to calculate the number of days out excluding weekends. can this be done in excel
Solved by A. A. in 16 mins
I have been toying with the problem for a few days. You have given good answere but I have been asking the wrong questions! I attac a file (What I want 3) which explains my needs
Solved by F. B. in 29 mins
So im having troubles coding this and was wondering if someone could just help!
- Copies column A of Sheet `Crew Members` to whatever the sheet name is entered in cell B1
- Some parameters`:
1) First, the sheet `Crew Members` will check the sheet `Terminated 75 days` to see if any names in both column A`s correspond and if a name is listed in `Terminated 75 days` then it will update the status (B column of Crew Members) to `Terminated BEFORE 90 days``
2)Then it will I guess sort all of the `Terminated BEFORE 90 days``, `Terminated AFTER 90 days`` and `Resigned` and make sure the statuses that say Àctive`or LOA will always be above.
Solved by G. L. in 21 mins
need to delete days work ,tried to add header and some how every page that was different was copied under the same header
eg every page was a different list now every page is the same under the same header title
Solved by V. W. in 14 mins