Wednesday, February 27, 2019

Excel tips

Some excel tricks on date computation.

Start Date 2004/01/04
End Date 2019/02/28

Compute: Day(s)    = datedif(startdate, enddate, "D")
        Month(s)  = datedif(startdate, enddate, "M")
        Year(s)   = datedif(startdate, enddate, "Y")


Excel Input:
Date now = ctrl + ;
Time now = ctrl + :