Forum Discussion

LarryDC's avatar
LarryDC
Copper Contributor
Apr 17, 2024
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 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!

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

     

2 Replies

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

     

    • LarryDC's avatar
      LarryDC
      Copper Contributor

      SanthoshKunder 

       

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

      @LarryDC

       

Resources