Forum Discussion
Date function to calculate an average between 2 dates
Let me add just a brief explanation. Calculating the number of days between two dates is quite easy, in fact. So long as a date appears in Excel as a numerical date (i.e. NOT text), it may be displayed as 1/1/21, but underneath is a number (44197 in that case). The number for today is found by using the function
=TODAY()
and for 11/2/21 that underlying number is 44502. So the count of days is a simple subtraction to find the difference between those two numbers.
The rest is straight forward math.
Here's a link to a website you might find useful for this (and, in the future, research into other functions_
https://exceljet.net/glossary/excel-date
Let me add just a brief explanation. Calculating the number of days between two dates is quite easy, in fact. So long as a date appears in Excel as a numerical date (i.e. NOT text), it may be displayed as 1/1/21, but underneath is a number (44197 in that case). The number for today is found by using the function
=TODAY()
and for 11/2/21 that underlying number is 44502. So the count of days is a simple subtraction to find the difference between those two numbers.
The rest is straight forward math.
Here's a link to a website you might find useful for this (and, in the future, research into other functions_
https://exceljet.net/glossary/excel-date