Subtract Dates In Excel | Subtract Years, Months and Days

[@IvanCortinas_ES]

Excellent Chester. DATEDIF, an important function in Excel. Great tutorial!!!

[@mitudas3173]

Thank you sir

[@vivekdsingh9008]

Thank You

[@zeinabsalem-n8g]

How Can I insert the function of datedif? because it is not in the program.

[@vivekdsingh9008]

V Good

[@nicolawright7308]

Is there any way to calculate weeks and days that automatically updates based on today's date?

[@rogerwillis7692]

=Today() in B3

[@yvettealejandro7610]

How about if i want to add & subtract
2 years 10 months 21 days
5 years 5 months 15 days
___________________________
Answer?

[@jeanegaboy548]

anyone can answer to this question?

[@Info-God]

This is weird. I do exactly the opposite. Based on a date selected from a calendar I populate 7 columns with: year, monthName, monthNo, DayName, DayNo, WeekNo, then I compose the date as a string of all. All in VBA for Excel-2010. Yup. The 2010.

[@sjh3099]

I get the error message "there is a problem with this formula" Strange