Date formulas in Excel

  • Thread starter Thread starter Glenn Suggs
  • Start date Start date
G

Glenn Suggs

Hello. I'm having some trouble putting together some date formulas that I
need in an Excel spreadsheet. The user is to type some past date in cell G2.
Formulas should be set up in other cells such that:
B2 = Years (since the G2 date)
C2 = Months (since G2)
D2 = Days (since G2)
E2 = Accumulated Days (total since the G2 date)
Can anyone help me with the quickest and most efficient solution?
Thanks in advance.
 
Glen
Format cells as "General"
B2 =DATEDIF(G2,TODAY(),"y")
C2 =DATEDIF(G2,TODAY(),"ym")
D2 =DATEDIF(G2,TODAY(),"md")
E2 =TODAY()-G2
You could replace TODAY() with a cell reference e.g. A2 and then enter any
date.
After formulae in B2, C2 & D2 you could enter &" year(s) ", &" month(s) ",
and &" day(s) " respectively.
Hope this helps
 
Back
Top