Thread: Excel formula to incrementally increase a value by 1 every day
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
  
Posts: 56
Default Excel formula to incrementally increase a value by 1 every day
Excel formula to incrementally increase a value by 1 every day.

If on July 12 a cell should start at 12,345 and increment by 1 daily, then putting this in the cell might help getting started:
=TODAY() - DATEVALUE("7/12/17") + 12345
Reply With QuoteReply With Quote