Recent Changes - Search:

PmWiki

pmwiki.org

edit SideBar

Date

=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 

                                     month and the same year 
Edit - History - Print - Recent Changes - Search
Page last modified on October 12, 2007, at 08:45 PM