MS Excel / VBA help thread

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

•

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).

•

rhb in reply to @aggi

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

It is prev month. The task is completed first week of the month, using last months data but rarely is done on 1st of the month, albeit that was the case today.

About

@aggi started