Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to convert a number into year/month/day. For example, the number 384 is equal to: 1 year, 19 days. Is there a formula that can calculate this?
 
For year and day this is easy (assuming, from your example, that all
years have 365 days):

A1: 384
A2: =INT(A1/365) & " year, " & MOD(A1,365) & " days)


However, you also ask for y/m/d - how long is a month? 28 days? 31
days?
 

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

Expanding Date formula 1
Year/Month/Date Question 4
Excel Subtracting multiple columns from another column 3
=IF(A2="","",TEXT(A2,"dddd")) 3
Convert a percentage to an hour 2
Calculating average ages 5
Vacation accrual formula needed 2
Month Formula 4

Back
Top