problem of converting days months and years

N

naughtyboy

Hi i have a problem in excel ..i m new of excel so dont have enough
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 24
months and 32 days so answer should be as 2 years 1 month and 2 days
because (24 months = 2 years and 32 days = 1 month and 2 days are left
as in the column of days).......

so plz help me thanks in advance......bye take care friendssss
 

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
problem of calculating years months and days 1
calculating Sick pay entitlement 2
problem with days months and years 0
DETERMINING NUMBER OF DAYS / MONTHS / YEARS BETWEEN TWO DATES 1
Add years, months, days to a date 5
A couple questions BEFORE using Office 365 0
Add/Sum up months, years, dates 6

Top