How to Calculate the Difference Between Two Dates​ in Excel

Could do with an English version of this with DD/MM/YY please

Hi there - Thank you for a great video!
Question/request: I would like have the a date interval repeated 4 times the automaticall update. Is that possible?
For example - I want the column to say 07/2/2023 - 07/08/2023 times 4 rows then update to the next week's interval.

didt know about 01.01.1990. thats cool. now i know why it shows the number when i change the date format to number format. thank you so much

I need some help, when I try to do the formula, it comes up with ###### and I do not know why, it is because mine is in a table?

❤❤❤I liked it too much.

HI Kevin, thanks you very much for all your videos and help. I have a problem where I have a table with 2 date fields, date call was logged and then if closed the date it was closed. I want a dynamic line chart to show received date and resolved date. Currently I have 2 pivots, cope then together and do a line chart from there and it works fine but it very manual. Any suggestions perhaps?

Is there a workaround for starting dates that occur before 1900 aside from deleting the formula for those cells and entering in the number of years manually.

Wa bi ismillah arahman arahim.

,& Y A ezzireg UN voucher grey ,& releas kit AS OK AF 🇲🇦 code black OSAS AF F = OI
( minster of seediiiiio )
Release,& 4 code name fortu 1-10R* doce F OK Y fez
Y F AO AS ,& A0 UN Black & grey ( nooor)
Doce fortu of ok AS kit green communication field code ( 93133)
Release street immediately F code ST ( 2397)
F fortu KIT Y YF as ok Y F = ( my wife )

Wa salatu wa Salam 3ala rasul allah saiduna Mohammed salah allah 3alayhi wa salam.

How start Date To End Date cab calculated adding End Date also to derive 90 days in a quarter period?

mine is August 12

Both the days of dates is to be counted. Say first of month 01-1-2023 to be counted till 25-01-2026

Thank you for the beautiful explanation

How would you calculate, the average role length, if you had multiple roles and within each role you had multiple contracts with different start and end dates?

THANK YOU! This was great! Liked and subscribed!

Hi Kevin Using Libre Calc not excel but much the same. If I have a column for days and have stopped the zero value showing can you put two formulas in a cell or column to avoid a result until the end date has been entered.

Hi Kevin, can you please explain 31 may 202 how to bring full year.

Hi! Thank you for the informations.
Can you help me calculate difference between more than 2 dates? For example, I have some hire with more than one date admission and I need sum those difference, to know when my employee complete work anniversary:

First admission: 02-02-2000 to 06-29-2004,
Second admission: 03-17-2006 to 04-10-2007
and third admission: 09-14-2008 to now .

Thank You!

What about months eh

hello Kevin, can you please provide a month to date versus previous month to date in excel , please

This actually helped me.. thank you

how to subtract one date from another and get the result in date format?

Is there a way to match birthdays in two different columns in excel?

I have a set of dates, some dates are blank and give the 41148 number ( which is a date) I just want it to return "0" for those. How do you do that?

I have been searching about calculation of probation period of a staff. Now, I've found it. You're the BEST teacher I've ever met. A million thanks to you.

Hi kevin
I follow your learning Youtupe, it is really useful. I have a request , is it possible to have your Whatsapp number in order to ask you some questions in vba please

That is great how about after calculating for the dates you like to hav the results in date and not number need answers please

getting the results in dates not number

It's result difference showing full date.... not number of days...
Why? On Google drive Excel sheet

This is exactly what I was looking for - Thank you for this vid!

Thanks Kevin. This was really helpful

Hi.i want enter date of february2022 in Excel between 1000 cells

Hi Kevin is there any way that it only counts weekdays in between two dates

thanks

when I tried that I got something like this for example: (6/10/1901). It's not providing me a number. The date format = ShortDate in Excel 365. Why is that?

How to remove 44577 after do after deducted today() from any date I want

Microsoft employee with Chrome on the Taskbar?

Sir,

It's not working when cells are merged/wrap..

Please, update.

Thank you

Thank you Kevin! How can I get the time lapsed between two dates in the following format (eg 12d:7h:25m)?

Hey my birthday too on Aug 11th...

OMG I WAS STUCK FOR HOURS THANK YOU

Great video,
However, it did not work if the date is set in the format YYYY-MM-DD.
What to do in this case?

I happen to see videoo on your birthday...so. Happy Birthday to Kevin

Tomorrow's your birthday?
Happy Birthday in advance, Kevin.

is there a formula to find prior dates....eg-when to start a task 25 days prior to a due date

Absolutely fantastic! To the point and easy to understand. I'd like to see how you would calculate dates with exceptions. Formulas which calculate daily fees excluding a particular day and holidays.

Tried the Today() and Now() functions - both returned a "name"-error

Hello Kevin, well explained, all your videos are, thanks. I am trying to create a spreadsheet that, hopefully, will calculate from hire date before yr 2000. Calculate hire date till retirement date (future date), and subtract years before 2000? the first step. I've been playing with datedif(), countif() yearfrac() and they are not getting the results. can you please help. thank you

Very nice content and perfect explanation. Loved you video alot .....making it a playlist of its own. ❤️