Date Formulas

michelle.lambert

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.

Example

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

Michelle Lambert

Jeff Reisman

Yes, make the Bill date column a Date-type column. Then you can just use

=[Contract Start Date]@row + 21

Or if the Day Value may change from row to row, you can use

=[Contract Start Date]@row + [Day Value]@row

Paul Newcome

Are you able to provide a screenshot for reference?

michelle.lambert

I am looking to add 21 days from the contract Start Date to the first Cycle date column.

Jeff Reisman

Yes, make the Bill date column a Date-type column. Then you can just use

=[Contract Start Date]@row + 21

Or if the Day Value may change from row to row, you can use

=[Contract Start Date]@row + [Day Value]@row