User Tools

Site Tools


datetime

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

datetime [2017/09/28 16:39] (current)
zeppo created
Line 1: Line 1:
 +  * =DATEDIF(E2,​ J2, "​M"​) 
 +  * Code  Description ​                      ​Explanation  
 +  * "​d" ​  ​Days ​                          The number of days between Date1 and Date2.  
 +  * "​m" ​  ​Months ​                        The number of complete months between Date1 and Date2.  
 +  * "​y" ​  ​Years ​                         The number of complete years between Date1 and Date2.  
 +  * "​yd" ​ Days excluding Years           The number of days between Date1 and Date2, as if Date1 and Date2 were in the same year.  
 +  * "​ym" ​ Months excluding Years         The number of months between Date1 and Date2, as if Date1 and Date2 were in the same year.  
 +  * "​md" ​ Days excluding Months & Yrs    The number of days between Date1 and Date2, as if Date1 and Date2 were in the same 
datetime.txt · Last modified: 2017/09/28 16:39 by zeppo