Solved How do I add 1 day forward in MS EXCEL....

February 29, 2016 at 22:10:18
Specs: Windows XP
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


See More: How do I add 1 day forward in MS EXCEL....

Report •


✔ Best Answer
March 1, 2016 at 05:18:46
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

http://www.skeptic.com/



#1
February 29, 2016 at 23:46:01
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


Report •

#2
March 1, 2016 at 00:15:01
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.


Report •

#3
March 1, 2016 at 00:48:38
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'



Report •

Related Solutions

#4
March 1, 2016 at 05:18:46
✔ 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

http://www.skeptic.com/


Report •

Ask Question