To calculate the difference or the number of days between two dates, you simply subtract one date from the other.
Example (using format:dd/mm/yyyy):
Suppose you have the date 25/11/2007 in cell A1 and the date 15/01/2008 in cell B1 (both cells formatted as date). To calculate the difference between these two dates you use the following formula:
=B1 [...]
This step-by-step article shows you how to calculate the number of months between any two dates.
To calculate the number of months between any two dates, use one of the following methods. Note that both methods use the following information:
• EDate = Earlier Date
• LDate = Later Date
NOTE: If you type LDate or EDate directly into this formula [...]
If you want the number of months occurring regardless of the day of the month then continue reading. If you want to calculate ‘whole month intervals’ by considering the day of the month, then check this post.
To calculate the number of months between two dates, there are two possibilities:
1. Both dates occur in the same [...]
To calculate the difference or the number of days between two dates, you simply subtract one date from the other.
Example (using format:dd/mm/yyyy):
Suppose you have the date 25/11/2007 in cell A1 and the date 15/01/2008 in cell B1 (both cells formatted as date). To calculate the difference between these two dates you use the following formula:
=B1 [...]
