Forum Discussion

Tknerd's avatar
Tknerd
Copper Contributor
Dec 04, 2020

Converting days into Years and Months not working for some data

Hi    I have the formula below and its returning incorrect data =INT(O83/365) & " years and " &MOD(O83,12)& " months"   O83 = 240 days   I am getting the result of 0 Years and 0 months.   Th...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 04, 2020

Tknerd 

As variant

=YEAR(O83)-1900 & " years " & (MONTH(O83)-1) & " months"

Resources