How do I make my Excel spreadsheet automatically calculate for the next invoice date in 20 days?

by on November 28, 2012

Q: I have a spreadsheet in Excel, how do I get it to automatically calculate for next invoice date in 28 days?


One Response to “How do I make my Excel spreadsheet automatically calculate for the next invoice date in 20 days?”
  1.  
    Picked as best answer

    Just add 28 to the date.

    So if your date of 11/28/2012 is in cell A1, in your next cell write “=A1+28”

    The cell will display 12/26/2012