Formulas with Conditions

Yessica

Hello,

My goal is to have a formula populate the dues dates with one condition. 

Currently Drawing Due Date is populated 2 weeks from Order Date

If the  "Type" Column is  "Q" then I need the Drawing Due Date to be 1 week from Order Date. 

Current Formula:      =$[Order Date]289 + 14

Thank you for helping me with this in advance. 

Shaine Greenwood

Hi Yessica,

Try something like this:

=IF(Type289 = "Q", $[Order Date]289 + 7)

Make sure that you're referencing the correct cell (correct column name and row number) when you use the above formula in your own sheet.

If that doesn't work, let me know what error you receive and I can help further.