# 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....

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)MIKEhttp://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 L5What 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+3Hope this helpsmessage 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+10This 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