Color
Definition Output cells
This method do not update to the current date automatically. This method update to the current date automatically.
Not Updated(Output) Formula Current Date 9/13/2009 CTRL ; at cell B3 for output Current Time 2:48 PM CTRL Shift ; at cell B4 for output
To see the formula in each cells, Go to any cell with formula, then press Ctrl + ~. Press Ctrl + ~ again to go back to normal output view.
Auto Updated(Output) Current Date Current Time
Formula 9/15/2009 =today() 9/15/2009 10:24 =now()
Your DOB(Date of Birth) Input DOB (Weekday) 12/31/1980 Age ( # Years) 12/31/1980 Age ( # Months)) 12/31/1980 Age ( # Days) 12/31/1980
Output Wednesday 28 8 15
Formula =TEXT(B9,"dddd") =DATEDIF(B9,Today(),"y") =DATEDIF(B10,Today(),"ym") =DATEDIF(B10,Today(),"md")
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv Time Start time End time No of Hours Input Note 37:30:55 <-- format cells, Time (37:30:55 format) 59:59:59 <-- format cells, Time (37:30:55 format) 22:29:04 <-- format cells, Time (37:30:55 format)
Must format the cells B23:B26 to Time format. Goto> menu Format cells, choose time format(37:30:55)
To make use of this function, Tools menu, Add-ins, Analysis Tool Pak option must be enabled.(Tick the check box)
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv Input Formula Date Joined Date Resigned 1/15/2001 1/1/2009 Years of service =("01/01/09"-B35)/365 7.9671233 # years =DATEDIF(B35,"01/01/09","y") 7.00 #Months =DATEDIF(B35,"01/01/09","ym") 11.000 #Days Week Number =DATEDIF(B35,"01/01/09","md") =weeknum(B36) 3 17.000 1