Date formula needed

Michelle Green

I am trying to write a formula to calculate a date 14 days prior to an entered date.

Example:

(entered) Date onsite 8/05/21

(calculated) Allocation date (auto calculate 14 days prior to entered date)

This is based on 7 days a week. Not a work week.

Does anyone have any tips regarding a formula to use?

Heather Duff

Hi! Be sure the date column you're working off of is set as a date column, and the column where you're entering the formula is set as a date column as well.

Here I'm assuming that your Date column is called Date.

=[date]@row - 14

Let me know if it works for you!

Best,

Heather

Heather Duff

Hi! Be sure the date column you're working off of is set as a date column, and the column where you're entering the formula is set as a date column as well.

Here I'm assuming that your Date column is called Date.

=[date]@row - 14

Let me know if it works for you!

Best,

Heather

Michelle Green

Thank you Heather! This worked perfectly!