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:

Search This Blog

Desktop Applications Training Blog

Jamie Johnson
JJSurf IT Training Ltd