View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

=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