If Statement Help

Lea722

Hello,

I'd like the +6 Days column to show the date in the manual adjustment column if the manual adjustment column has a date. If the manual adjustment column is blank, I'd like the +6 Days column to show the start date plus 6 days. Any ideas on how to adjust the formula below? Thanks!

Lindsay

NickStaffordPM

Try this out

=IF(ISBLANK([Manual Adjustments]@row),[Start]@row+6,[Manual Adjustments]@row)

The ISBLANK function is a great way to create logical frameworks around blank cells.

Let me know if this does not work!

SoS | Dan Palenchar

Hi @Lea722,

Try this formula in the +6 Days column:

=IF(ISDATE([Manual Adjustments]@row), [Manual Adjustments]@row, Start@row+6)

Hope that helps!

NickStaffordPM

Try this out

=IF(ISBLANK([Manual Adjustments]@row),[Start]@row+6,[Manual Adjustments]@row)

The ISBLANK function is a great way to create logical frameworks around blank cells.

Let me know if this does not work!

SoS | Dan Palenchar

Hi @Lea722,

Try this formula in the +6 Days column:

=IF(ISDATE([Manual Adjustments]@row), [Manual Adjustments]@row, Start@row+6)

Hope that helps!

Lea722

Thank you so much, @NickStaffordPM and @SoS | Dan Palenchar! Both solutions worked like a charm :)