Results 1 to 3 of 3

Thread: Convert days into years, months and days in Excel

  1. #1

    Convert days into years, months and days in Excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How to convert days into years, months and days in Excel:
    I want to convert lets say 1888 Days from today to Years Months, Days!!
    Ex: 1888 Days = 6 years, 3 months and 21 days
    What is the formula???
    Thanks

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Don't know what the formula would be to get that, but you could try this

    =DATEDIF(TODAY(),TODAY()+1888,"Y") & " years, "& DATEDIF(TODAY(),TODAY()+1888,"YM") & " months and " & DATEDIF(TODAY(),TODAY()+1888,"YM") & " days"

  3. #3
    Quote Originally Posted by NoS View Post
    Don't know what the formula would be to get that, but you could try this

    =DATEDIF(TODAY(),TODAY()+1888,"Y") & " years, "& DATEDIF(TODAY(),TODAY()+1888,"YM") & " months and " & DATEDIF(TODAY(),TODAY()+1888,"YM") & " days"
    Great, thanks you!

Posting Permissions

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