MS Excel / VBA help thread

You are reading a single comment by @rhb and its replies. Click here to read the full conversation.

•

aggi in reply to @chez_jay

Ah yes, I skimmed through and thought the cut off formula was
=MONTH(TODAY()-1)

•

rhb in reply to @aggi

thought the cut off formula was

=MONTH(TODAY()-1)

This is how I was using it (in part of a longer Concat with Year) and once applying Chalfie's fix it worked.

•

aggi in reply to @rhb

I wasn't sure what you were going for (previous month or yesterday's month).

About

Avatar for rhb @rhb started