Workday formula - value 1 to return value 0's date

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

Why don't you simply input 0 in Column E?

Else change your formula to

=WORKDAY(F$6,$E10-1)

Also not sure why your are referring column B for holiday list

Try

=WORKDAY(F$6,IF($E10=1,0,$E10))