ExcelBanter - Excel formula to incrementally increase a value by 1 every day

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel formula to incrementally increase a value by 1 every day (https://www.excelbanter.com/excel-worksheet-functions/453644-excel-formula-incrementally-increase-value-1-every-day.html)

[email protected]

Excel formula to incrementally increase a value by 1 every day

Excel formula to incrementally increase a value by 1 every day.

Thanks in Advance.

MyVeryOwnSelf[_3_]

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

All times are GMT +1. The time now is 06:59 PM.