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

Подписаться 255 тыс.

Просмотров 60 тыс.

50% 1

Excel VBA/Macro Course [80% Discount]: www.teachexcel...
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:
Download the File: www.teachexcel...
TeachExcel Online Courses: www.teachexcel...
DATEDIF (Microsoft Resource): support.micros...
Calculate Difference Between Two Dates (Microsoft Resource): support.micros...
#msexcel #tutorial #exceltips #freetutorial #exceltips #excel

Опубликовано:

2 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@savemoney911 25 дней назад

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?

@MohammedSaeedAwad 8 месяцев назад

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

@VishnuVardhan-vq6bd День назад

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

@valauramiddleton686 Год назад

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

@முச்சந்தி 10 месяцев назад

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

@scopeswabi5809 7 месяцев назад

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.

@mmgaffoor 4 месяца назад

Great, thankyou

@sandeepbhandari3130 5 месяцев назад

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

@bchill0829 11 месяцев назад

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

@nadermounir8228 Год назад

A very nice and interesting tutorial 👍 👌

@DaviODonnell 10 месяцев назад

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".

@pancux670 4 месяца назад

Put , after years in your formula. datedif(date1,date2,"y")& "years, "& datedif(date1,date2,"ym")&" months, "&datedif(date1,date2,"md")&" days"

@syedikramullah1114 Год назад

Nice

@cityviewhotel7664 8 месяцев назад

Great & Thanks a lot for uploading video.

@user-zf2bk5cz8m Год назад

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