EOMONTH/WORKDAY question

[RobsterM]

Hi guys, In cell A1 I need to get todays date i.e =today() or 5 Sept 2015 - that's what I can do.. In cell A2 I need to see the last working day of the previous month i.e. 31 Aug, in cell A3 I need the previous last working day i.e. 31 July. Ive used EOMONTH but I struggle with the cell A2 because it defaults to 30 Sept which hasn't happened yet! and the WORKDAY incorporation - any ideas?

Also, I would be really handy to get the public holidays in there, where if the last working day of the month was a public holiday the formula would revert to the day prior.

All of this will be going into a chart where I'll will be trying to use OFFSET to make the chart living - instead of asking about this i'll do my own trial and errors.

Any help much appreciated.

Cheers,
Rob

 

[LikeButtah]

Try looking at this to help you get what you need. Good Luck

http://www.mrexcel.com/forum/excel-...ble-give-last-working-day-previous-month.html

 

[RobsterM]

Thanks, that solves it!