Using if condition in excel sheet.

[Closed]
Report
-
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.

Can any one assist on this