Chris thanks for the great explanation of this function. Just thinking of way to apply it. One situation would be for calculating seniority dates for say shift assignments or promotions.
What formula would I use to calculate where there is no date. So, Column A is Start date, Column B is Closed date, Column C is Running time (days). I want to know the running time regardless of whether it is closed or not. So if its not closed i need it to calculate to "today's" date, but if there is a close date to the date it was closed. Ive done it before but cannot remember how
Why the result of 31/07/2020 & 30/09/2020 is 1 Month using Datedif(start_date,end_date,"M") instead of 2 months? The problem is with all such months having 31 days, the result is always less than one month.
This is great. However, I am working with genealogy and have dates from the 17th, 18th, and 19th centuries. your formulas will not work with dates in the 20th and 21st centuries.
Great explanation.Thank you so much
You are welcome!
Thank you for perfect explanation.
Thanks for the clip Chris. There is so much i need learn and quickly for a spreadsheet, but not sure where to start.
Chris thanks for the great explanation of this function. Just thinking of way to apply it. One situation would be for calculating seniority dates for say shift assignments or promotions.
What formula would I use to calculate where there is no date. So, Column A is Start date, Column B is Closed date, Column C is Running time (days). I want to know the running time regardless of whether it is closed or not. So if its not closed i need it to calculate to "today's" date, but if there is a close date to the date it was closed. Ive done it before but cannot remember how
nice. put excel file link download in the description ===
chrismenardtraining.com/Files/DownloadFile.aspx?FUID=535cea01-9b52-42b4-928b-45d471855e9c
Chris, How would I obtain "Months" in the future? I get negative numbers. I require "Months until due date" on a financial spreadsheet. Thanks!
Why the result of 31/07/2020 & 30/09/2020 is 1 Month using Datedif(start_date,end_date,"M") instead of 2 months? The problem is with all such months having 31 days, the result is always less than one month.
This is great. However, I am working with genealogy and have dates from the 17th, 18th, and 19th centuries. your formulas will not work with dates in the 20th and 21st centuries.
Or, all together in one row: =DATEDIF(A1;B1;"Y")&" year(s), "&DATEDIF(A1;B1;"ym")&" month(s) and "&DATEDIF(A1;B1;"md")&" day(s)"