today and datedif function #excel #exceltips #excelformula #excelfunction #msoffice #exceltutorial

Dated if function, by this function we can calculate the age of the person like no of year, month and days completed as of today,

To know today date formula is =today()
To know no of years completed formula is =DATEDIF(B5,C5,"y")
To know no of month completed formula is =DATEDIF(B5,C5,"ym")
To know no of days completed formula is = =DATEDIF(B5,C5,"md")

Видео today and datedif function #excel #exceltips #excelformula #excelfunction #msoffice #exceltutorial канала LAV_xcl