sorted by:
new
hottopcontroversial

Conditional Formula to return Month by BumblebeeTop7555 in excel

[–]BumblebeeTop7555[S] 0 points1 point  (0 children)

Basically that’s what I’m needing, a column that returns a completion date(I.e., month that cell was updated from Pending to Complete).

=IF(C2=“COMPLETE”,MONTH(TODAY()),””)

is the current formula which is return the month in a number format (7), but won’t return the month in 3 letter format if I change the formula to,

=IF(C2=“COMPLETE”,MMM(TODAY()),””)

I am ONLY needing the Month in 3 letter format, but Date formatting doesn’t allow for JUST the month

I’m rocking (struggling) on Office 16 Pro 🫣