Forum Discussion
Populate dates based on reference cell
Hello! I am working on creating a spreadsheet to track the progress of a project with multiple people starting on different dates. Essentially what I would like to do would look something like: ...
excelstentialdread Another way to generate a range of dates automatically, without the need to copy them across, would be by using the SEQUENCE function, as shown in the attached picture. It requires one extra column, though, where you indicate the duration for the project for each person. Just make sure that the cells that this formula spills into are all formatted as Date.