Forum Discussion
Solved
calculation of prorated rent
How do get Excel in MS365 to calculate the days remaining in the current month? Also how do I get the exact total number of days for the existing month. Lastly, this window I am in keeps telling me...
- How do get Excel in MS365 to calculate the days remaining in the current month? -
=EOMONTH(TODAY(),0)-TODAY()- Also how do I get the exact total number of days for the existing month.
=DAY(EOMONTH(TODAY(),0))
- How do get Excel in MS365 to calculate the days remaining in the current month? -
=EOMONTH(TODAY(),0)-TODAY()
- Also how do I get the exact total number of days for the existing month.
=DAY(EOMONTH(TODAY(),0))
Thank you very much for the quick responce. Both of the help answers work great. Thanks again.
@LarryDC
