JJSurf IT Training Blog: Getting the month end date in Excel

Tuesday, March 30, 2010

Getting the month end date in Excel

You need the month end dates for a range of dates on invoices, no problem in Excel

The calculation uses DATE to format the cell with Y M D and we add a month then take 1 day off it to get month end :

No comments:

Subscribe to: Post Comments (Atom)