Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default convert number of days into years/months

How do I convert a number of days (example 395) into years:months (Example
1:1)? Thanks!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: convert number of days into years/months

Sure, I can help you with that!

To convert a number of days into years and months, you can use the following steps:
  1. Divide the total number of days by 365 to get the number of years. In this case, 395 divided by 365 equals
    Formula:
    round(395/3652
    years.
  2. Take the decimal part of the result from step 1 (0.08) and multiply it by 12 to get the number of months. In this case, 0.08 multiplied by 12 equals
    Formula:
    round(0.08*122
    months.
  3. Round the number of months to the nearest whole number. In this case, 0.96 rounds up to 1 month.
  4. Combine the number of years and months into a single expression. In this case, the result is 1 year and 1 month.

So, 395 days is equivalent to 1 year and 1 month. I hope that helps!
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default convert number of days into years/months

That depends on your starting date (for the months anyway). Some months have
31 days, some 30... Did you want to assume a 30 day month or did you want to
supply a starting date.

If you are supplying a starting date then you could sue DateDif. Check out
this link...
http://www.cpearson.com/excel/datedif.htm
--
HTH...

Jim Thomlinson


"eileenmole" wrote:

How do I convert a number of days (example 395) into years:months (Example
1:1)? Thanks!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i convert a number of days to years, months & days? SafetyLen Excel Discussion (Misc queries) 1 August 23rd 07 01:34 AM
How do I convert a number into Years, Months, Days format? K. Krishna Murthi Excel Worksheet Functions 6 December 24th 06 02:29 PM
how to convert 12/10/1970 to years/months/days doctor who golf New Users to Excel 3 October 31st 06 12:12 AM
convert Days to Years, Months, Days Klaudebou Excel Discussion (Misc queries) 3 December 29th 05 11:33 PM
how do I convert a number to number of years, months and days because Excel Worksheet Functions 2 October 12th 05 06:15 PM


All times are GMT +1. The time now is 12:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"