Using dates in a formula for text/number columns
I have text/number columns that represent weeks in a project timeline template. I want to be able to keep the column names generic (Week 1, Week 2, etc) and have the Monday date of each week in Row 1. Projects last months to over a year, so manually typing these dates in is tedious. The ideal scenario would be to put in the Monday corresponding to Week 1 then have a formula in the remaining Week # columns to count forward. However, when I set this up, this is what happens. The formula in Week 2 is (=[Week 1]@row + 7)
Week 1 Week 2
I can't format the columns to be dates because the data in the rows below are not dates. Is there a formula out there that can read the date format or a date format that I can use where the text/number columns would understand what I'm trying to do?
My short term solution is to set this up in an external software where the aforementioned formula works and copy and paste the dates in. I'd like to be able to keep it all in one sheet.
Help Article Resources
Check out the Formula Handbook template!