Using formulas to automate a date
Hello! I have a column that identifies a specific week, e.g., week 1, week 2, etc. I would like to create another column that automates a specific date based on week entry. For instance if Week 1 is entered, the date 1/25/21 is automatically entered in the date column. Thank you for your help!
Help Article Resources
Check out the Formula Handbook template!