title: Creating an excel cell that resets at the start of every month
body: <p>I am trying to create an Excel cell the tells me whether someone has paid rent for the month. Because rent is monthly, I would like the cell to reset to False at the start of every month and remain like so until someone changes it to true, after which it will reset again to false when theres a new month. </p>
  
  <p>I have tried playing around with the Date and Time function by creating the following cell function <code>=if(Day(Today())==1, False, True)</code> however the obvious problem with this is that the cell doesn't remain False after the first day of the month. How should I approach this problem? Are there any other Excel Functions I should use?</p>