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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a formula that will let me know 60 days prior to my budget consumption reaching 75%.
Solved by A. H. in 19 mins
User Solver to find find the schedule that meets demand from attendance levels while minimizing payroll costs for employees working five consecutive days with two days off.
Solved by T. E. in 16 mins
Hello I'm using the Agile Gantt Chart template in Excel but want to know how to change the timescale from days to weeks?
Solved by V. J. in 26 mins
i would like to detail out my attendance sheet with all columns and a number to control the days from crossing the limit
Solved by A. E. in 30 mins
I'm creating a timeline for projects and want to use a formula to create a gantt chart that adds prep days before the event and connects to a color coded legend. I have the inspiration for my chart and the chart I've made so far.
Solved by F. H. in 20 mins
I need help I am still learning how to use excel but I need formula to find the number of days since exams in column F and tell formula to add hyphens in the cells that equal nothing.
Solved by G. H. in 25 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 Z. Y. in 25 mins
hey I can't seem to access drop down menus on some things on the toolbar. For example, the drop down arrow next to the border options won't work. I click it, and literally nothing happens. No options are presented. It was working fine just a few days ago, now suddenly it won't work and I have tried multiple different excel files and documents. What is the problem?
Solved by E. H. in 18 mins
Hi, I have 1 spreadsheet with two tabs. On my first sheet I have on hand inventory consisting of an item description and on hand count taken from a few days ago. On my 2nd sheet I have the same item description and a count that was sold. I am trying to create a vlookup on my 1st page to look at the item description and if that appears in Column H:H then to take the number corresponding to the sold item and place it on the first page in a new column next to the old item count. Hope this makes sense...
Solved by O. B. in 11 mins