Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dates
Resolved · Low Priority · Version 2007
Alex has attended:
Excel Intermediate course
Excel Advanced course
How can i convert days into year/months/days?
I.e 2834 days =
x Years
x Months
x Days
Hello Alex
Thank you for your question and welcome to the forum.
You can use the DATEDIF function as part of a text string to take a number of days and display X years Y months Z days.
If the number of days is in cell A1, enter the following to make the conversion in another cell:
=DATEDIF(0,A1,"y")&" years "&DATEDIF(0,A1,"ym")& " months "&DATEDIF(0,A1,"md")&" days"
The spaces around years and months have been put in purposefully so that the result will display with spaces in these positions in the result you will get. The & symbols create the string.
Kind regards
Amanda
Fri 11 Sep 2009: Automatically marked as resolved.
|
|
Excel tip:Line breaks in a cellYou can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
