Get the Days, Months, & Years Between Dates in Excel (1 Formula)

preview_player
Показать описание

How to output the difference between two dates, showing the days, months, and years between those dates.

This tutorial uses one single formula that I show you how to build and change for your needs.

Resources:

#msexcel #tutorial #exceltips #freetutorial #exceltips #excel
Рекомендации по теме
Комментарии
Автор

why i can't find (datedif) equation title in my excel ?

MohammedSaeedAwad
Автор

A very nice and interesting tutorial 👍 👌

nadermounir
Автор

That's very helpful. Many thanks!

TeresaBuenavista-oj
Автор

Great & Thanks a lot for uploading video.

cityviewhotel
Автор

What should I do if I need the answer in this formula?
01 year, 01 Month, 01 Day

முச்சந்தி
Автор

Can you help me? I am trying to get: Years, Months, Days. This formula works for Years and Months (but no 'days')
=DATEDIF(G2, H1, "Y") & " Years, " & DATEDIF(G2, H1, "YM") & " Months "
But when I try to add the "Days" like the following, I get an error
=DATEDIF(G2, H1, "Y") & " Years, " & DATEDIF(G2, H1, "YM") & " Months ", " & DATEDIF(G2, H1, "YMD") & " Days "
Can you help me reveal the Years, Months and Days?

savemoney
Автор

Dear sir please help me this is date of joining 12-04-22 sir present i have date of joining after which how to get my required date by formula

VishnuVardhan-vqbd
Автор

Now do the same thing for dates before 1900. I am a genealogist.

valauramiddleton
Автор

What format change can I make if my date range is 12/1/1985-12/7/1992? It is coming up "7 Years6 Days" but I need it to say "7 Years, 6 Days".

DaviODonnell
Автор

If we read 1 year as 1 year 3 months, then how many years, months and days will there be in 1 year 6 months and 10 days

sandeepbhandari
Автор

Dear Sir, if there is no date in cell B2; then the formula cell shows this *NUM!, kindly tell me how to replace *NUM! with blank cell or show some message like "please put date in cell B2" or any other solution, Kindly answer me.

scopeswabi
Автор

Dates formula doesn't include end date, 10 FEB 24

bchill
Автор

1 Years? and 1 months? Come on, tidy it up with something like a simple if statement to show Month and Year if singular and Months and Years if plural

zfbkczm