Get instant live expert help on time and date display

“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

When I enter a date in the format 02-02, my Excel 2013 sets the date to 02-Feb. I need it to display Day-Month-Year in the format 01-01-****, can someone tell me how to change it so it will display this date all the time on all worksheets?
Solved by D. F. in 25 mins
Need help with date and time calculator. I need to calculate time in hours before surgery from a date and time of surgery and date and time of injury
Solved by K. C. in 18 mins
A formula is needed that will look at a row, find the most recent date out of multiple in dates in the row, and then display the cell that is to the left of the most recent date. Thank you so much for your time, Blake
Solved by T. D. in 29 mins
How do I set up a column in Excel to display 'age next birthday', given birth date and today's date?
Solved by M. Q. in 23 mins
Hello I would like to know if the following conversion is possible in excel in cell 1 I have date and time information currently formatted from the cell format menu as (dd/mm/yy hh/mm) in cell 2 I have the number of minutes that a process will take - this number is usually around 2,000 - 3,000 minutes in cell 3 is it possible to display the completion date and time of the process?
Solved by S. J. in 11 mins