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

Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course...
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.com/excel-tuto...
TeachExcel Online Courses: www.teachexcel.com/premium-co...
DATEDIF (Microsoft Resource): support.microsoft.com/en-us/o...
Calculate Difference Between Two Dates (Microsoft Resource): support.microsoft.com/en-us/o...
#msexcel #tutorial #exceltips #freetutorial #exceltips #excel

Пікірлер: 19

  • @MohammedSaeedAwad
    @MohammedSaeedAwad5 ай бұрын

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

  • @nadermounir8228
    @nadermounir822811 ай бұрын

    A very nice and interesting tutorial 👍 👌

  • @cityviewhotel7664
    @cityviewhotel76645 ай бұрын

    Great & Thanks a lot for uploading video.

  • @alfarhangroup505
    @alfarhangroup50511 ай бұрын

    thank you ..very nice Explaintaion

  • @mmgaffoor
    @mmgaffoorАй бұрын

    Great, thankyou

  • @syedikramullah1114
    @syedikramullah111411 ай бұрын

    Nice

  • @mehrebevon2561
    @mehrebevon256118 сағат бұрын

    ❤❤❤

  • @user-zl3cl6nu6c
    @user-zl3cl6nu6c7 ай бұрын

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

  • @user-hq4dp1ch7y
    @user-hq4dp1ch7y7 ай бұрын

    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

    @pancux670

    2 ай бұрын

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

  • @sandeepbhandari3130
    @sandeepbhandari31302 ай бұрын

    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

  • @scopeswabi5809
    @scopeswabi58094 ай бұрын

    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.

  • @valauramiddleton686
    @valauramiddleton68611 ай бұрын

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

  • @bchill0829
    @bchill08298 ай бұрын

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

  • @sandeepbhandari3130
    @sandeepbhandari31302 ай бұрын

    Plz make excel formula

  • @iceshcratiote3635
    @iceshcratiote36358 ай бұрын

    Were og kv

  • @user-zf2bk5cz8m
    @user-zf2bk5cz8m11 ай бұрын

    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

  • @hokeyfuckstorm

    @hokeyfuckstorm

    3 ай бұрын

    Agreed. I'm a newbie at Excel but a fanatic about language use. Can you guide me to the correct formula to eliminate plurals when necessary?

Келесі