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
Hello,

I need the Formula in Excel sheet

If A2 is having a date. I need the date on C2 After 2 days. If the second day is Saturday it should be indicate the Monday Date. If the seconday days is Sunday also it should be indicate the Monday Date..

In the same way on D2 I need the third day from Cell A2. Above criterial applies the same (If the third day is Saturday it should be indicate the Monday Date. If the third days is Sunday also it should be indicate the Monday Date.

Expecting your favorable reply in this regards.

Thanks and Regards
Kannan


Related:

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