problem of calculating years months and days

N

naughtyboy

Hi i have a problem in excel ..i m new of excel so dont have enoug
knowledge so do help me ..suppose i have the following data
A2 = Years = 9
B2 = Months = 175
C2 = Days = 392

i want to calculate these months and dates as supoose i have 0 years 2
months and 32 days so answer should be as 2 years 1 month and 2 day
because (24 months = 2 years and 32 days = 1 month and 2 days are lef
as in the column of days).......

so plz help me thanks in advance......bye take care friendsss
 
P

paul

how do you want to define a month? in a normal year one month is 30.41667
days.In a leap year a month is 30.5 days,over a period of four years
including a leap year a month is 30.4375 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

problem of converting days months and years 3
years-months-days-hours 8
number of months and days between two dates without approximation 3
problem of converting days months and years 0
convert # of years, months and days 4
Problem With Converting Days Months And Years 1
how do I work out age in years, months, days in excel 1
Probem Of Converting Days Months And Years 0

Top