CF Checklist Excel Forum.xlsm
Hi there
Attached is a spread sheet in which I have used a WORKDAY formula to return the relevant dates
However, I would ideally like Working Day 1 to return the date generated by entering 0, e.g.
cell F10 has the formula
cell E10 represents the 'working day' from which the date is generated in cell F10
Ideally I would like the value (date) returned from entering '0' in column E, to be the same from entering '1'
You can see in row 11 that entering the value 1, pushing the date out to 04/11/2013, whereas I would like the value 1, to return the date 01/11/2013
I've tried a couple of things which haven't worked
Any help would be much appreciated
Thanks, Maddy
Bookmarks