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
http://www.jjsurf.co.uk/