I'm just stumped on this date function. Can someone help me please?

Rhea

I have a sheet that is tracking projects for our team. I have one column that is "Asset Due Date" and I want another column "TD Due Date" to auto populate a date that is 28 days prior to the date chosen for "Asset Due Date". Both columns are set up as date column types. I've played with the date function and just can't seem to get it to work. Anyone have any insight?

Tomasz Giba

Hi @Rhea

Try this:

=[Asset Due Date]@row - 28

Make sure date only restriction is off:

Let us know if this is what you were looking for.

Good Luck!

Tomasz Giba

Tomasz Giba

Hi @Rhea

Try this:

=[Asset Due Date]@row - 28

Make sure date only restriction is off:

Let us know if this is what you were looking for.

Good Luck!

Tomasz Giba

Rhea

Thank you so much Tomasz! This worked!