Here are some problems that our users have asked and received explanations on
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
I need a formula to extract the date from "assigned 01/03/2018 10:11 am" text and that excel would recognize the date as a proper date so that I could compare which date is earlier to another date