Get instant live expert help on date month year
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need formula of year month & date that gives reult of year.
Solved by B. C. in 21 mins
I am trying to figure out how to take a fiscal year field and month field and create a date in xx/xx/xxxx format in Excel.
The fiscal year is October -September. If the month is October November or December, the date will correspond to the previous year of the fiscal year (ie if the month is "October" and the fiscal year is 2010- the date would read "10/1/2009").
Solved by Z. H. in 26 mins
The below formula result in a "FALSE" result when there is no date in Column D. I want it to return the value in Column E.
=IF($D74<>"",IF(MONTH(F$73)&YEAR(F$73)<=MONTH($D74)&YEAR($D74),$E74,IF(MONTH(F$73)&YEAR(F$73)>MONTH($D74)&YEAR($D74),0)))
Solved by B. B. in 24 mins
HOW I CAN SPLIT DAY, MONTH & YEAR INTO 3 COLUMNS FROM DATE COLUMN.
Solved by T. C. in 28 mins
Please change the revenue column to be able to be filtered by date/month/year time.
Solved by E. S. in 13 mins