IF Statement with Dates

John Littler

Need help with a nested IF statement?

Please see attached, I need to automatically change the ACTUAL DATE column by adding the number of days in the DAYS column to the ESTIMATED DATE column based on the TEAM column?

Any help is appreciated!

Thx

IF on Dates.jpg

Kimberly Loveless

if I am understanding correctly you would do something like

=IF(TEAM@row = "DOP", [Estimated Date]@row +90 ,IF(TEAM@row ="IOP", [Estimated Date]@row+60,IF(TEAM@row = "LEAN", [Estimated Date]@row+30

Kimberly Loveless

if I am understanding correctly you would do something like

=IF(TEAM@row = "DOP", [Estimated Date]@row +90 ,IF(TEAM@row ="IOP", [Estimated Date]@row+60,IF(TEAM@row = "LEAN", [Estimated Date]@row+30

John Littler

@Kimberly Loveless ... worked like a charm! Thanks so much.