calculation of prorated rent

[LarryDC]

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 · Accepted solution]

@LarryDC 

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))​

[#3]

@SanthoshKunder 

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

@LarryDC