Thread
:
Converting number of days to years and months
View Single Post
#
2
N Harkawat
Posts: n/a
=INT(A1/365)&" years "&INT(MOD(A1,365)/30)&" months"
"Dave Cobb" wrote in message
news:rfLke.1280$5T2.1163@trnddc01...
I want to convert the number of days in a cell (ie: 2350) to Xyears and
Ymonths. What formula to use?
Thanks,
Dave
Reply With Quote