Nov 28 2021 08:02 PM
Nov 28 2021 10:32 PM
@faalmutawa Let's say the start date is in A1 and the end date in A2. Enter the following formula in any empty cell, to calculate the number of days between these two dates:
=A2-A1+1
Format the cell with this formula as "General".
If you want to calculate the number of days to go from today's date until the end, use this one:
=A2-TODAY()+1
Format the cell with this formula as "General".
Divide the number by 30 and you roughly end-up with the number of months.
Nov 28 2021 11:11 PM
Another option is the DATEDIF function
"Months"
= DATEDIF(start,end,"m")
"plus days"
= DATEDIF(start,end,"md")
QUOTIENT and MOD would provide similar values from @Riny_van_Eekelen's count of days.