Previous Topic Next Topic

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


1 response

Answer 1 / 1
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses