SOLVED

# calculation of prorated rent

Copper 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!

2 Replies
best response confirmed by LarryDC (Copper Contributor)
Solution

# Re: calculation of prorated rent

1. 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))​``

# Re: calculation of prorated rent

Thank you very much for the quick responce. Both of the help answers work great. Thanks again.

@LarryDC

1 best response

Accepted Solutions
best response confirmed by LarryDC (Copper Contributor)
Solution

# Re: calculation of prorated rent

1. 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))​``