Fill Month Category From a Date Time Stamp.

Brendan Ginns

Hi, I am wondering if there is an IF statement that can fill the month Category ( January, February, March, April, May, June, July, August, September, October, November, and December.) From a time stamp Column (April-7-2022) and If the date is within the range of the month of April it will populate the column category with April.

Please let em know.

Thanks,

Brendan

Andrée Starå

Hi @Brendan Ginns

I hope you're well and safe!

Try something like this.

=IF(ColumnName@row <> "", IF(MONTH(ColumnName@row) = 1, "01 January", IF(MONTH(ColumnName@row) = 2, "02 February", IF(MONTH(ColumnName@row) = 3, "03 March", IF(MONTH(ColumnName@row) = 4, "04 April", IF(MONTH(ColumnName@row) = 5, "05 May", IF(MONTH(ColumnName@row) = 6, "06 June", IF(MONTH(ColumnName@row) = 7, "07 July", IF(MONTH(ColumnName@row) = 8, "08 August", IF(MONTH(ColumnName@row) = 9, "09 September", IF(MONTH(ColumnName@row) = 10, " 10 October", IF(MONTH(ColumnName@row) = 11, "11 November", IF(MONTH(ColumnName@row) = 12, "12 December")))))))))))))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!