Hi All,


For some reason I seem to be stuck on a formula which should be simple to do

Formula in cell D2
Start date in cell B2
Column D is known as "End Date"

So far I have got as far as - =IF(A2="Night", B2+1,B2)

What I have done so far is, if A2="Night" then it is adding 1 day to the start date, to give the end date. If it does not equal "Night" then the end date will be the same as the start date.
However, what I want it to do is add 1 day to the start date, if A2= Night or Night (B) - But I can't seem to get it working.

Any help would be much appreciated.