Date formula

IDM

Hello,

I need help with a date formula, I need to enter a date and once enter 10 weeks are subtracted from that date. New date will be displayed. Thank you.

Heather Duff

Hi @IDM ,

Because 10 weeks = 70 days, you should be able to use the following formula:

=[date column]@row - 70

Be sure both columns are set to Date within the properties of the column.

Hope this helps! Let me know if it works for you.

Best,

Heather

Heather Duff

Hi @IDM ,

Because 10 weeks = 70 days, you should be able to use the following formula:

=[date column]@row - 70

Be sure both columns are set to Date within the properties of the column.

Hope this helps! Let me know if it works for you.

Best,

Heather

IDM

@Heather Duff Thank you, this helped!

Heather Duff

@IDM Happy to help! Have a great day.