Converting number of days

R

Radrays

How can I convert a number into days, months and possibly years?

I have the number 195.4642 which equals a number in days. I need that
number represented as months and days.

I am currently using XP - Office 2007

Thank you,
Radrays
 
D

David Biddulph

So how many days do you think are in a month? Doesn't it depend on the date
from which you start counting?

Try =DATEDIF(B1,A1+B1,"y")&" years, "&DATEDIF(B1,A1+B1,"ym")&" months,
"&DATEDIF(B1,A1+B1,"md")&" days"
with your number of days in A1 and the starting date in B1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Using project as a resource tracker 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Calculate number of days 7
REINSTALLING MS OFFICE PRO PLUS 2019 0
A couple questions BEFORE using Office 365 0
Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute 9
Subtracting two cell dates and highlight if over due by a certain amount of days 0

Top