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

Add a nested IF function in cell F18 to indicate that Customers with a Credit Rating of 1 have 30 days to pay, Customers with a Credit Rating of 2 have 15 days to pay, and Customers with a 3 are C.O.D.
Solved by I. A. in 14 mins
How can I use a drop down select to reference another tab on the same spreadsheet? Using another template but customizing. A friend would like to replicate a sheet that I am currently using "Employee Report" which would pull data from the "event tracker" tab and create a calendar view of all days taken off and have an employee selected from the drop down.
Solved by E. A. in 25 mins
I am chatting for the last 2 days, but no one was able to help me with it. I need some help with my VBA file. pls help, just need help you get the output in different format.
Solved by K. A. in 13 mins
I want something which will read eBay product link and write available quantity in stock. Something like stock checking code. Please help me, I am trying this from many days.
Solved by A. Y. in 17 mins
I've been working on a report for days now. The report is generated with all info in one column. I attempted a million and ten ways to split up the info but nothing worked. I was even trying some tranpose pasting and I dont know what I did but whatever it was was perfect. I am trying to do the same and can't figure out what I did. Please help
Solved by C. A. in 30 mins
Someone from here named sudhans said to pay him in paypal then he will sent the solution to my mail but it has been 3 days and I haven't got it yet.
Solved by F. F. in 18 mins
Someone from here named sudhans said to pay him in paypal then he will sent the solution to my mail but it has been 3 days and I haven't got it yet. FYI, I want to get the total number of cars sold, total amount sold and average discount for each manufacturer in summary sheet.
Solved by C. H. in 17 mins
1- In my columns M, N and O, I need to have no values within them if Column M has no value 2- Column 0 needs to represent the difference of days between today and column N 3- Could columns L, M, N and O be compressed on a 2nd sheet, only showing the lines that have values entered for column L?
Solved by V. U. in 27 mins
I would like to parse information based on a name (Column B) and count how many days you find the word absent (Column D)
Solved by T. W. in 22 mins
I need help with formula in excel for roster spread sheet. I have part of the formula but can not add additional function to duplicate the function on the same line. The roster is 4 days on and 4 night shifts, and 4 days off and then the next cycle is 5 days on 5 night shifts and then 5 days off.
Solved by B. C. in 21 mins