Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2012
    Posts
    20
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Excel 2010 date formula

    Hi,

    I have a need to display the difference in dates in a year and month format. Column A is the start date for a project (Jan 2, 2009), column B is the completed date (Mar 15, 2011). In column C I need to display the time between A and B as years and months. I know I can do column C in days format ormonths format or complete years, but then I don't want to convert it again to my final format.

    Is there any easier way to display the results as year and month?

    Thanks,

    Chris

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    =DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "

    If you want to include the days as well:
    =DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    the_couchguards (2013-06-14)

  4. #3
    New Lounger
    Join Date
    Nov 2012
    Posts
    20
    Thanks
    9
    Thanked 0 Times in 0 Posts
    Hi Steve, that's it. Perfect. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •