I have cell L1 as a date of completed task, cell L5 will be my target submission date which is 3 days after L1, so it will be "=L1+3". However, if it falls on a Sunday I need it to add 1 more day so cell L5 will fall on a Monday. I need your assistance, please and thank you

✔ Best Answer

Just an observation. Since we are only concerned about Sunday,

that means Thursday will always be the 3rd day before.So you could also use:

=IF(WEEKDAY(L1)=5,L1+4,L1+3)

MIKE

You can try something like this =IF(WEEKDAY(L1+3)=1,L1+4,L1+3)You can paste this formula into L5

What this does is check the weekday of L1+3, if it returns a 1 which is Sunday, it will then add 4 to L1, otherwise it will keep it as L1+3

Hope this helps

message edited by AlwaysWillingToLearn

It helped a lot, thanks. I have no clue on excel syntax so I did was add first and then make an IF condition and it gave me some sort of cycle-thing error. Yours is very helpful and much appreciated, thank you very much.

Glad it worked and thanks for letting us know. You are probably talking about the 'Circular Reference Warning' This usually occurs when a formula within a cell depends on the result of the same cell. for example if in A2 you have

=A2+10

This cannot work because the formula relies on the value of A2, and it cannot calculate itself. If you need more information on this Google 'Circular Reference Warning'

Just an observation. Since we are only concerned about Sunday,

that means Thursday will always be the 3rd day before.So you could also use:

=IF(WEEKDAY(L1)=5,L1+4,L1+3)

MIKE

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History