How to Calculate the Difference Between Two Dates- in Excel - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Prosperity
Hi Kevin, you are an AMAZING instructor. I am new to excel and I'd like to know if I can use excel to create a software (what formula) to populate answers for predetermined data subjects. I am not sure if I explain correctly here but here's an example. Under the -Subject- data, I have -Non-Existence- with bullet points 1. DC, 2. NP (these letters stand for a paragraph). And then there will be a -Goal- and -Result- button. Under -Result-, I want to calculate/bring specific answers bullet points from the -Subject- data based on the conditions under -Goal.- I hope this means sense to you and thank you for your help.
reply
Hi Kevin, you are an AMAZING instructor. I am new to excel and I'd like to know if I can use excel to create a software (what formula) to populate answers for predetermined data subjects. I am not sure if I explain correctly here but here's an example. Under the -Subject- data, I have -Non-Existence- with bullet points 1. DC, 2. NP (these letters stand for a paragraph). And then there will be a -Goal- and -Result- button. Under -Result-, I want to calculate/bring specific answers bullet points from the -Subject- data based on the conditions under -Goal.- I hope this means sense to you and thank you for your help.
reply
Shah
Hi
I have a question?
Like if we have to just calculate the no of calendar days from the start date to end date including the dates I am giving e.g start date is 24/02/2020 and the end date is 29/02/2020 typically if we calculate it on fingers it will come up with 6 days and if we give a simple formula (end-date - start date) it comes up with the answer 5 days. How can I calculate it with the correct number of days?
Hope I am clear with my question if not, please reply so that I can elaborate further.
Thanks
reply
Hi
I have a question?
Like if we have to just calculate the no of calendar days from the start date to end date including the dates I am giving e.g start date is 24/02/2020 and the end date is 29/02/2020 typically if we calculate it on fingers it will come up with 6 days and if we give a simple formula (end-date - start date) it comes up with the answer 5 days. How can I calculate it with the correct number of days?
Hope I am clear with my question if not, please reply so that I can elaborate further.
Thanks
reply
Edward
can you please help me..
I received a Document on 23-Jul-20.
Then I want to count the day I received the Document til today but excluding the holidays and day-off (Rest Day-Fri. and Sat.)
How can I formula it in Today Function.?
This is the Sample.
In Column Width A1 - 23-Jul-20 (I received the Document)
In Column Width B1 - 1 (starting counting days of the received documents excluding day off/rest day and holidays)
reply
can you please help me..
I received a Document on 23-Jul-20.
Then I want to count the day I received the Document til today but excluding the holidays and day-off (Rest Day-Fri. and Sat.)
How can I formula it in Today Function.?
This is the Sample.
In Column Width A1 - 23-Jul-20 (I received the Document)
In Column Width B1 - 1 (starting counting days of the received documents excluding day off/rest day and holidays)
reply
JO
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
reply
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
reply
Kevin
Kevin, I have an Excel file for P&L Projections. On the second page of the file is a Loan Amortization Table. I am trying to figure out how to use xlookup to find the current month's interest expense (found in the Amortization Table), based on the date the file is opened.
reply
Kevin, I have an Excel file for P&L Projections. On the second page of the file is a Loan Amortization Table. I am trying to figure out how to use xlookup to find the current month's interest expense (found in the Amortization Table), based on the date the file is opened.
reply
Vishwa
What about dates in the 5-digit day range? How do we calculate the difference between dates that are (for example) 170 years in the past until a later that might be today or in the 1950s?
We used to use DATEDIF() but that no longer works, apparently.
reply
What about dates in the 5-digit day range? How do we calculate the difference between dates that are (for example) 170 years in the past until a later that might be today or in the 1950s?
We used to use DATEDIF() but that no longer works, apparently.
reply
Jennifer
Times almost up! Your birthday is now TOMORROW! - Enjoy the day.
Related future content request: my line of business needs to calculate age in whole years, and never round up. E.g. Age 25.79 should just be age 25. Thank you!
reply
Times almost up! Your birthday is now TOMORROW! - Enjoy the day.
Related future content request: my line of business needs to calculate age in whole years, and never round up. E.g. Age 25.79 should just be age 25. Thank you!
reply
Tesnobay
Hi, in the cell for the date Toothbrush Installed, shouldn't the date be hard coded instead of =now(), because the date will change everyday you reopen it, and the formula below it will just add 90 to the new date?
reply
Hi, in the cell for the date Toothbrush Installed, shouldn't the date be hard coded instead of =now(), because the date will change everyday you reopen it, and the formula below it will just add 90 to the new date?
reply
Michele
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.
reply
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.
reply
Roy
Do you have a good way to calculate age? For example: today - my birthday = age in years. Answer is in days and I usually divide by 365.25. The .25 to account for leap years.
reply
Do you have a good way to calculate age? For example: today - my birthday = age in years. Answer is in days and I usually divide by 365.25. The .25 to account for leap years.
reply
Add a review, comment
Other channel videos
