Changing a Date (mm/dd/yyyy) to Month Year (January 2019)

Duane B

I copied this from another post and simply substituted my date range (from another sheet) and It is returning "UNPARSEABLE".  Any suggestions?

=IFERROR(IF(MONTH(@{Quality Database Range 1}@row) = 1, "January ", IF(MONTH(@{Quality Database Range 1}@row) = 2, "February ", IF(MONTH(@{Quality Database Range 1}@row) = 3, "March ", IF(MONTH(@{Quality Database Range 1}@row) = 4, "April ", IF(MONTH(@{Quality Database Range 1}@row) = 5, "May ", IF(MONTH(@{Quality Database Range 1}@row) = 6, "June ", IF(MONTH(@{Quality Database Range 1}@row) = 7, "July ", IF(MONTH(@{Quality Database Range 1}@row) = 8, "August ", IF(MONTH(@{Quality Database Range 1}@row) = 9, "September ", IF(MONTH(@{Quality Database Range 1}@row) = 10, "October ", IF(MONTH(@{Quality Database Range 1}@row) = 11, "November ", IF(MONTH(@{Quality Database Range 1}@row) = 12, "December ")))))))))))) + YEAR(@{Quality Database Range 1}@row), "")

Andrée Starå

Hi Duane,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD