calulate number of days in number of months.

**visha_1984** · 10-28-2013, 06:16 AM

Hi Team,

I need formula
i have working days count ,and need Number of month

exmp:- 30 - 1 month
60 - 2 Month
35 - 1 month 5 Days
70 - 2 month 10 Days,
365- 1 year

Thanks in advance

**Pete_UK** · 10-28-2013, 06:21 AM

If you have 361 days (or 362, 363, 364), what result would you want from that ?

Pete

**visha_1984** · 10-28-2013, 06:30 AM

Hi Pate,

thanks for your quick reply

if 361 days = 11 month remaining days

**ramananhrm** · 10-28-2013, 06:40 AM

Please confirm if you are looking for this result.

=IF(A1>=365,ROUNDDOWN(A1/365,0)&" yrs "&MOD(A1,365)&" days",ROUNDDOWN(A1/30,0)&" months "&MOD(A1,30)&" days")

**visha_1984** · 10-28-2013, 06:50 AM

Originally Posted by ramananhrm

Please confirm if you are looking for this result.

=IF(A1>=365,"1 year",ROUNDDOWN(A1/30,0)&" months "&MOD(A1,30)&" days")

Hi ,Ramananhrm

i just check formula but if days 750 it should return 2 year 20 days.

361 12 months 1 days
365 1 year
750 1 year
1050 1 year150 5 months 0 days
30 1 months 0 days

**ramananhrm** · 10-28-2013, 07:43 AM

Please try this function.

=IFERROR(IF(A1>=365,ROUNDDOWN(A1/365,0)&" yrs "&ROUNDDOWN(MOD(A1,365)/30,0)&" months "&MOD(MOD(A1,365)/30,ROUNDDOWN(MOD(A1,365)/30,0))*30&" days",ROUNDDOWN(A1/30,0)&" months "&MOD(A1,30)&" days"),IF(A1>=365,ROUNDDOWN(A1/365,0)&" yrs "&MOD(A1,365)&" days",ROUNDDOWN(A1/30,0)&" months "&MOD(A1,30)&" days"))

Rgds,