If Formula require to calculate No of Days
Closed
Learner

May 5, 2010 at 02:03 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  May 5, 2010 at 08:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  May 5, 2010 at 08:49 AM
Related:
 If Formula require to calculate No of Days
 How to calculate 90 days from date in excel  Guide
 Skype last seen days ago  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Number to words in excel formula  Guide
 Date formula in excel dd/mm/yyyy  Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 5, 2010 at 05:58 AM
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)), D1C1, IF(AND(A1>C1, B1>C1), B1A1, IF(AND(A1>C1, ISBLANK(B1)), D1A1, "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)), D1C1, IF(AND(A1>C1, B1>C1), B1A1, IF(AND(A1>C1, ISBLANK(B1)), D1A1, "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,