You need the month end dates for a range of dates on invoices, no problem in ExcelThe 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 :
A collection of all things helpful for MS Office applications users, from a wandering IT Trainer. www.jjsurf.co.uk