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
 - Formula to calculate vat in excel - Guide
 - Skype last seen days ago - Guide
 - Logitech formula vibration feedback wheel driver - Download - Drivers
 - Number to words in excel formula - Guide
 - Excel add days to date - 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)), 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,