IF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three columns

F is dates
G is dates
H is where the formula is

I would like the formula to show if the date in G is greater than the date
in F show Overdue, else if G is less than F show Complete, else if the date
in G changes from what it currently shows then show Forecast Change.

Any help with this would be greatly appreciated. I realise I may have to
customise this for each row to show the different dates currently displayed
in column G.

Cheers
Nic
 
In H2
=IF(G2<>DATEVALUE("10/23/1999"),"Forecast
Change",IF(G2>F2,"Overdue",IF(F2<=G2,"Complete","")))

If you don't check for the changed date first, then either Overdue or
Complete will display.
 
Back
Top