Requesting Formula in excel on if condition / date function
Closed
KANNAN

Mar 9, 2015 at 03:49 AM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015  Mar 9, 2015 at 08:27 AM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015  Mar 9, 2015 at 08:27 AM
Related:
 Requesting Formula in excel on if condition / date function
 Excel date format dd.mm.yyyy  Guide
 Number to words in excel formula  Guide
 Mark sheet grade formula in excel download  Guide
 Formula bar in excel missing  Guide
1 reply
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Mar 9, 2015 at 08:27 AM
Mar 9, 2015 at 08:27 AM
Try this in C1
=IF(OR(WEEKDAY(A1,2)=1,WEEKDAY(A1,2)=2,WEEKDAY(A1,2)=3,WEEKDAY(A1,2)=6),A1+2,IF(WEEKDAY(A1,2)=7,A1+1,IF(WEEKDAY(A1,2)=5,A1+3,IF(WEEKDAY(A1,2)=4,A1+4,""))))
and this in D1
=IF(OR(WEEKDAY(C1,2)=1,WEEKDAY(C1,2)=2,WEEKDAY(C1,2)=3,WEEKDAY(C1,2)=6),C1+2,IF(WEEKDAY(C1,2)=7,C1+1,IF(WEEKDAY(C1,2)=5,C1+3,IF(WEEKDAY(C1,2)=4,C1+4,""))))
Not sure you wanted 2 days on the second. If you are trying to build a week you might need to tamper with the second one a bit.
=IF(OR(WEEKDAY(A1,2)=1,WEEKDAY(A1,2)=2,WEEKDAY(A1,2)=3,WEEKDAY(A1,2)=6),A1+2,IF(WEEKDAY(A1,2)=7,A1+1,IF(WEEKDAY(A1,2)=5,A1+3,IF(WEEKDAY(A1,2)=4,A1+4,""))))
and this in D1
=IF(OR(WEEKDAY(C1,2)=1,WEEKDAY(C1,2)=2,WEEKDAY(C1,2)=3,WEEKDAY(C1,2)=6),C1+2,IF(WEEKDAY(C1,2)=7,C1+1,IF(WEEKDAY(C1,2)=5,C1+3,IF(WEEKDAY(C1,2)=4,C1+4,""))))
Not sure you wanted 2 days on the second. If you are trying to build a week you might need to tamper with the second one a bit.