Forum Discussion
LarryDC
Apr 17, 2024Copper Contributor
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 to SAVE REGULARLY. WHERE IS THAT SAVE BUTTON??
GUESS I AM TOT
ALLY BLIND BESIDES BEING NEW TO THE COMMUNITY !!
Thanks for any and all help!
- 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))
2 Replies
Sort By
- SanthoshKunderIron Contributor
- 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))
- LarryDCCopper Contributor
Thank you very much for the quick responce. Both of the help answers work great. Thanks again.
@LarryDC