Get instant live expert help on how to extract date from datetime in excel

“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

Im having some excel date format problems. I need to calculate time until surgery. And I have found the formula, but I cant get the last DATETIME format from row 1133 to fit.
Solved by I. C. in 13 mins
UNABLE TO EXTRACT YEAR FROM DATE USING YAER FUNCTION
Solved by Z. W. in 29 mins
i want to extract from a date the year and month to be in the format yearly-monthly as a number/date not text
Solved by O. D. in 23 mins
How do I extract the month and year froma date and display it in the format mmm-yy?
Solved by C. W. in 13 mins
I have a database in Excel 365 of results, with a row for each member for each date, giving their result for that date if they competed. I want to extract from the database the result from their last four appearances
Solved by C. Y. in 15 mins