Formula Date

Shimy

Am I able to create a date 4 weeks prior to a specific date through a formula? So, every entered PM Requested Ship Date would auto generate a Required process completion Date... Do I use =DATE( OR =IF( Thanks!

John Shane

@Shimy

Should just be able to use a basic subtraction in the Required process completion Date column.

=[PM Requested Ship Date]@row - 28

Cheers,

John

John Shane

@Shimy

Should just be able to use a basic subtraction in the Required process completion Date column.

=[PM Requested Ship Date]@row - 28

Cheers,

John

Shimy

You are awesome. I was making it way more complicated for no reason. Thank you!

John Shane

No problem. Overcomplication is coding is easy to do. Sometimes easy is right. 😂

Shimy

Amen to that!