John Davis
Well-known Member
- Joined
- Sep 11, 2007
- Messages
- 3,457
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.
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.