Hi,
I currently have a a very simple formula in place.
In A1 I enter a date and in A2 the formula is =A1-2
What I would like to know is, is there a way I can adapt this formula so that it will automatically give me the nearest working day that it a minimum of 2 working days from the date in A1?
e.g If A1 is 7th May 2012 (Monday) then my current formula would mean A2 will be 5th May 2012 which is a Saturday. In this scenario, I would like it to automatically change this to Friday 4th May.
I have had a go with the WORKDAY and NETWORKDAY functions but they seem to only calculate the number of working days between 2 dates?
Any advice would be very much appreciated....
Bookmarks