IF FORMULA AND 2 DATE COLUMNS

Melanie Sanders

Hello,

I am wanting to capture a date into a current date column if there is a date in the second column. Example: If NEW EXP DATE has a new date, I would like that date to display in the CURRENT EXP DATE column. If there is not a date in the NEW EXP DATE column, then I would like to keep the current date in the CURRENT EXP DATE. Any ideas is really appreciated.

Thank you!

Protonsponge

Hello @Melanie Sanders,

If you had a column that is detailing the original column, one option could be to use an IF(ISBLANK formula.

In the example below, if [New Expiry Date] is blank, then it will show the date in [Expiry Date], if [New Expiry Date] is not blank, then it will show the date in [New Expiry Date]

=IF(ISBLANK([New Expiry Date]@row ), [Expiry Date]@row , [New Expiry Date]@row )

I hope that is helpful to you in some way,

Protonsponge

Melanie Sanders

@Protonsponge thank you for your quick response. This gives me an circular reference error. Do you have any other suggestions?

Melanie Sanders

@Protonsponge I just noticed that you created a new column. That formula did work! It poses another issue for me though but will try and work through it.

Thank you!