Insert Cell Value based on criteria

[tjc154]

I want to create a formula in Column X that returns a value of TBD if no date is populated in a Column U. Once a date is populated in column U, TBD will change to a date in column X.

I tried the below formula

=IF(COUNTBLANK(U25)>0,"TBD",=SUM(U25+2)

The date format I'm using is m/dd/yy

Thoughts

Thank you

Tom

 

[Rick Rothstein]

I want to create a formula in Column X that returns a value of TBD if no date is populated in a Column U. Once a date is populated in column U, TBD will change to a date in column X.

I tried the below formula

=IF(COUNTBLANK(U25)>0,"TBD",=SUM(U25+2)

See if this does what you want...

=IF(U25="","TBD",U25+2)

 

[tjc154]

Thank you that worked perfectly.

I need to make one more modification to the formula in another cell.

If the value in column X is TBD it will place a TBD value in Column Y. Otherwise it will take the date in column X and add +1 to that value in column Y so it returns a date. I tried several variations of you formula but its not working.

Thank you

Tom

 

[Rick Rothstein]

I need to make one more modification to the formula in another cell.

If the value in column X is TBD it will place a TBD value in Column Y. Otherwise it will take the date in column X and add +1 to that value in column Y so it returns a date. I tried several variations of you formula but its not working.

Based on your description, I think this should work for you...

=IF(X25="TBD","TBD",X25+1)

 

[tjc154]

Thank you again. That worked.

Happy Holidays!!!