How to use dateif function to get years, months and days between two dates

[kelly mort]

Hello,

I need help with how to use the dateif function to get the date difference between two dates that's today's date and a date inside a textbox say TextBox1 in vba.

I want it shown in years, months and days.

Example : 1 year, 10 months and 11 days

Thanks in advance
Kelly

 

[Niteshnitesh]

=DATEDIF(B6,C6,"y") &" years,"&DATEDIF(B6,C6,"ym") &" months," &DATEDIF(B6,C6,"md") &" days"

 

[Niteshnitesh]

B6 is your start date and c6 is end date. In C6 you can use =today() function to count till today's date. It's working fine for me. Have a nice day

 

[kelly mort]

Is there a vba code for this?