IF
 

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

IF
 

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

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

--
Regards,
Tom Ogilvy




"Nic" wrote:

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