Dateadd Function

[John Davis]

Hello All:

I have the following date add function in Excel. It is set too read the previous month. Question how would I alter this too read the current month?? Would it be ("m", 1, Date) or ("m", 0, Date)??

(DateAdd("m", -1, Date), "MMM YYYY")

Any help would be appreciated.

 

[DonkeyOte]

it seems you're just returning a text variation of a date, given you don't want to add to current date why not just use

FORMAT(date,"MMM YYYY")

 

[John Davis]

it seems you're just returning a text variation of a date, given you don't want to add to current date why not just use

FORMAT(date,"MMM YYYY")

Thanks for your reply. I'll take your suggestion. It's most likely what I should be doing.