How To Extract Month And Year Only From A Date and if the date column is blank Return Blank?

Mindfull · 07/08/20

Hi All,

I have to generate a monthwise report to show how many Requests are in a particular month I tried the following formula. I have also added IF(ISBLANK()""), so that it leaves the cell blank if the date is not there in the [Request Received Date] column. One it is not considering the Year and well as throwing #INVALID OPERATION error.

=IF(ISBLANK([Request Received Date]@row), "", IF(MONTH([Request Received Date]@row) = 1, "January", IF(MONTH([Request Received Date]@row) = 2, "February", IF(MONTH([Request Received Date]@row) = 3, "March", IF(MONTH([Request Received Date]@row) = 4, "April", IF(MONTH([Request Received Date]@row) = 5, "May", IF(MONTH([Request Received Date]@row) = 6, "June", IF(MONTH([Request Received Date]@row) = 7, "July", IF(MONTH([Request Received Date]@row) = 8, "August", IF(MONTH([Request Received Date]@row) = 9, "September", IF(MONTH([Request Received Date]@row) = 10, "October", IF(MONTH([Request Received Date]@row) = 11, "November", IF(MONTH([Request Received Date]@row) = 12, "December")))))))))))))

Please Help!

Mindfull · 07/09/20

Hi Paul,

It is resolved I used following

=IFERROR(IF(MONTH([Request Received Date]@row) = 1, "January", IF(MONTH([Request Received Date]@row) = 2, "February", IF(MONTH([Request Received Date]@row) = 3, "March", IF(MONTH([Request Received Date]@row) = 4, "April", IF(MONTH([Request Received Date]@row) = 5, "May", IF(MONTH([Request Received Date]@row) = 6, "June", IF(MONTH([Request Received Date]@row) = 7, "July", IF(MONTH([Request Received Date]@row) = 8, "August", IF(MONTH([Request Received Date]@row) = 9, "September", IF(MONTH([Request Received Date]@row) = 10, "October", IF(MONTH([Request Received Date]@row) = 11, "November", IF(MONTH([Request Received Date]@row) = 12, "December")))))))))))) + " " + YEAR([Request Received Date]@row), "")

Paul Newcome · 07/08/20

Do you NEED to have the month in text, or could you use something along the lines of "07/20" for July of 2020?

Mindfull · 07/09/20

Hi Paul,

It is resolved I used following

=IFERROR(IF(MONTH([Request Received Date]@row) = 1, "January", IF(MONTH([Request Received Date]@row) = 2, "February", IF(MONTH([Request Received Date]@row) = 3, "March", IF(MONTH([Request Received Date]@row) = 4, "April", IF(MONTH([Request Received Date]@row) = 5, "May", IF(MONTH([Request Received Date]@row) = 6, "June", IF(MONTH([Request Received Date]@row) = 7, "July", IF(MONTH([Request Received Date]@row) = 8, "August", IF(MONTH([Request Received Date]@row) = 9, "September", IF(MONTH([Request Received Date]@row) = 10, "October", IF(MONTH([Request Received Date]@row) = 11, "November", IF(MONTH([Request Received Date]@row) = 12, "December")))))))))))) + " " + YEAR([Request Received Date]@row), "")