I am looking to set up a Date function.
I have multiple dates on a sheet, I need to set a column or multiple columns up with a formula to automatically calculate.
1 column has a Start date (date column property)
I want another column to calculate 21 days ahead when that will bill, and so on for each 21 days..
Do I make the bill date column a Date property?
What is the formula I use, I have searched but can only find =Date2 =21 which doesn't work because I have multiple dates on a line I need the formula to grab a specific column and count forward.
Thank you for your help and suggestions in advance
Help Article Resources
Check out the Formula Handbook template!