🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
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.
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.
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?
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.
@kevinstratvert Do you have a video about Datediff formula? The date diff calculates the months/ years between 2 dates, but i need to round it up. If I put in employee started on 1 July and end on 30 July it say worked 0 months. I need it to show worked 1 month. Please help
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, 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?
Hi Kevin, when I do the substraction, I do not get the answer in days, but instead in a date format such as 9/1/1900. Do you know why this might be the case and how to rectify?
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?
Hi I like watching your videos they are very helpful, I need to know how to creat a list where the dates change automatically from week by week for a time sheet.
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.
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
Hello In My Excel, I have two columns I have shared the data of my columns. Column1: 2023-07-24T06:44:03.000Z Column2: 2023-07-24T06:44:16.000Z How do I get these two columns different in "Seconds" Only?
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!
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
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.
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?
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!
How to calculate the difference between 2 date/time ranges in business days? For example, cell A2: 07-Jul-23 18:00hrs and B2: 09-Jul-23 10:00hrs The result in C2 should reflect "00 Days 06 Hours" since Saturday and Sunday must be completely excluded in the calculation. I tried all possible options including chat GPT but failed
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
Here are some I've done: Pie Charts: th-cam.com/video/nuNwAu74xwY/w-d-xo.html Line Graph: th-cam.com/video/3o11OlLgYDo/w-d-xo.html Let me know if there are others that would be helpful.
How do I get the number of days between two days, counting the start date as day 1. Example 11/2/23 and 11/2/23 the formula gives you zero but I want it to count it as 1
This is the flaw with using the “days” function and/or subtracting one date from another; it yields the answer minus one. For example, 1/1/24 through 1/31/24 indicates “30” days which we know is wrong. So, do this to obtain the correct answer: “=days(date-date)+1” OR “=days(cell-cell)+1 OR “=(cell-cell)+1”. My insurance company fixed this by using the first day of the FOLLOWING month (1/1/24 through 2/1/24) which added that extra day, but is visually incorrect. Hope this helps.
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)
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.
The following has a bunch of potential ways of calculating age: support.office.com/en-us/article/Calculate-age-113D599F-5FEA-448F-A4C3-268927911B37 Using the =YEARFRAC(,now()) function seems to work pretty well.
I have a spreadsheet (or part of one--it daoesn't get the gregorian date from julian day number). Instead of using January 1,1900 as day 1,it use January 1, -4713. No PRACTICAL use for it, but it's a good academic excercise.
![เป็นไปได้ไหม - WanMai [Official MV]](http://i.ytimg.com/vi/_6lZ6b3_7Vo/mqdefault.jpg)
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
You are my best excel Teacher!
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.
OMG I WAS STUCK FOR HOURS THANK YOU
I happen to see videoo on your birthday...so. Happy Birthday to Kevin
nope... still get error values... so frustrating. even when I change the values it wont change some cells...
Change the format of cell
I am getting #value! error... what am I doing wrong?
Same
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.
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
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 for the beautiful explanation
Tried the Today() and Now() functions - both returned a "name"-error
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.
Thanks Kevin. This was really helpful
Microsoft employee with Chrome on the Taskbar?
@kevinstratvert Do you have a video about Datediff formula? The date diff calculates the months/ years between 2 dates, but i need to round it up. If I put in employee started on 1 July and end on 30 July it say worked 0 months. I need it to show worked 1 month. Please help
This is exactly what I was looking for - Thank you for this vid!
Very nice content and perfect explanation. Loved you video alot .....making it a playlist of its own. ❤️
Hi Kevin is there any way that it only counts weekdays in between two dates
This actually helped me.. thank you
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, 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?
Yeah, that’s a good catch. I would start with =now() and then copy and paste the value.
Hi Kevin, can you please explain 31 may 202 how to bring full year.
How start Date To End Date cab calculated adding End Date also to derive 90 days in a quarter period?
Is there a way to match birthdays in two different columns in excel?
Hi Kevin, when I do the substraction, I do not get the answer in days, but instead in a date format such as 9/1/1900. Do you know why this might be the case and how to rectify?
Could do with an English version of this with DD/MM/YY please
THANK YOU! This was great! Liked and subscribed!
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?
Tomorrow's your birthday?
Happy Birthday in advance, Kevin.
Hi I like watching your videos they are very helpful, I need to know how to creat a list where the dates change automatically from week by week for a time sheet.
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.
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
Great video,
However, it did not work if the date is set in the format YYYY-MM-DD.
What to do in this case?
Hello
In My Excel, I have two columns
I have shared the data of my columns.
Column1: 2023-07-24T06:44:03.000Z
Column2: 2023-07-24T06:44:16.000Z
How do I get these two columns different in "Seconds" Only?
how to subtract one date from another and get the result in date format?
Is it working for 12 months of 30 days or 12 months of 30 & 31 days also i.e. 365 days?
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!
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
Still waiting for a reply to my question
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?
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.
hello Kevin, can you please provide a month to date versus previous month to date in excel , please
Thank you Kevin! How can I get the time lapsed between two dates in the following format (eg 12d:7h:25m)?
lol im having to create a report where I can calculate dates from tickets ticket response vs sla breached xD
is there a formula to find prior dates....eg-when to start a task 25 days prior to a due date
Sir,
It's not working when cells are merged/wrap..
Please, update.
Thank you
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?
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!
Why if i do the way it comes to me VALUE error?
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?
How to calculate the difference between 2 date/time ranges in business days?
For example, cell A2: 07-Jul-23 18:00hrs and B2: 09-Jul-23 10:00hrs
The result in C2 should reflect "00 Days 06 Hours" since Saturday and Sunday must be completely excluded in the calculation.
I tried all possible options including chat GPT but failed
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
Hi.i want enter date of february2022 in Excel between 1000 cells
Thank you. You helped me.
So brilliant! Thank you!
How to remove 44577 after do after deducted today() from any date I want
It's result difference showing full date.... not number of days...
Why? On Google drive Excel sheet
please do tutorial on basic excel charts and advanced charts
Here are some I've done: Pie Charts: th-cam.com/video/nuNwAu74xwY/w-d-xo.html Line Graph: th-cam.com/video/3o11OlLgYDo/w-d-xo.html Let me know if there are others that would be helpful.
How do I get the number of days between two days, counting the start date as day 1. Example 11/2/23 and 11/2/23 the formula gives you zero but I want it to count it as 1
This is the flaw with using the “days” function and/or subtracting one date from another; it yields the answer minus one. For example, 1/1/24 through 1/31/24 indicates “30” days which we know is wrong. So, do this to obtain the correct answer: “=days(date-date)+1” OR “=days(cell-cell)+1 OR “=(cell-cell)+1”. My insurance company fixed this by using the first day of the FOLLOWING month (1/1/24 through 2/1/24) which added that extra day, but is visually incorrect. Hope this helps.
dude 2.6 mil subscribers !!!
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)
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.
The following has a bunch of potential ways of calculating age: support.office.com/en-us/article/Calculate-age-113D599F-5FEA-448F-A4C3-268927911B37
Using the =YEARFRAC(,now()) function seems to work pretty well.
@@KevinStratvert Thank much. Keep those great videos coming.
❤❤❤I liked it too much.
I have a spreadsheet (or part of one--it daoesn't get the gregorian date from julian day number). Instead of using January 1,1900 as day 1,it use January 1, -4713. No PRACTICAL use for it, but it's a good academic excercise.
It doesn't work is it different for UK date
Both the days of dates is to be counted. Say first of month 01-1-2023 to be counted till 25-01-2026
Total number of days should be 25 days without adding plus 1 day formula
Not getting result as shown
What about the time ?!
i get error
thanks
Hey my birthday too on Aug 11th...
Cool
What about months eh
mine is August 12
It worked yeet