If Formula require to calculate No of Days
Closed
Learner
-
May 5, 2010 at 02:03 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- If Formula require to calculate No of Days
- Excel formula for vat calculation - Guide
- Formula to increment date by seven days. ✓ - Forum - Excel
- Calculate no of days left from today to a future specified date ✓ - Forum - Excel
- If condition formula required ✓ - Forum - Excel
- Formula to add big number of day to date in excel sheet ✓ - Forum - Excel
1 reply
rizvisa1
May 5, 2010 at 05:58 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
May 5, 2010 at 05:58 AM
LET SAY
DP is in cell A1
DS is in cell B1
PBD is in cell C1
PED is in cell D1
you can write in E1 this
=IF(AND(A1<> "", B1<>"", A1<C1, B1<C1), 0, IF(AND(A1<C1, ISBLANK(B1)), D1-C1, IF(AND(A1>C1, B1>C1), B1-A1, IF(AND(A1>C1, ISBLANK(B1)), D1-A1, "None of 4 conditions"))))
DP is in cell A1
DS is in cell B1
PBD is in cell C1
PED is in cell D1
you can write in E1 this
=IF(AND(A1<> "", B1<>"", A1<C1, B1<C1), 0, IF(AND(A1<C1, ISBLANK(B1)), D1-C1, IF(AND(A1>C1, B1>C1), B1-A1, IF(AND(A1>C1, ISBLANK(B1)), D1-A1, "None of 4 conditions"))))
May 5, 2010 at 07:48 AM
How can I resolve this thing.
Please help
Regards
May 5, 2010 at 08:00 AM
May 5, 2010 at 08:21 AM
Please advice,
Thanks & Regards,
May 5, 2010 at 08:26 AM
May 5, 2010 at 08:37 AM
Regards,