Conditional formatting with dates

[Brentsa]

Good day,

I have two columns with dates:
Column E: Date when person was trained: ie 01 Jan 2019
Column F: Due Date (when person must be trained again - a year from Column E: used this formula: =DATE(YEAR(E4)+1,MONTH(E4),DAY(E4))

I need a formula that will be able to say if Column F is Overdue, Outstanding or Current.

Overdue is if Column F is past Today's date
Outstanding is if Column F has not passed but still needs to be done this year
Current is if Column F is a date that is the following year

I got as far as =IF(ISBLANK(F4),"",IF(F4<TODAY(),"Overdue","Outstanding")) but have no idea to get the formula to give me "Current" result

 

[Fluff]

How about

+Fluff New.xlsm
	E	F	G
4	01/01/2019	01/01/2020	Overdue
5	01/10/2019	01/10/2020	Outstanding
6	29/02/2020	28/02/2021	Current
Data

Cell Formulas
Range	Formula
F4:F6	F4	=EDATE(E4,12)
G4:G6	G4	=IF(E4="","",IF(F4<=TODAY(),"Overdue",IF(YEAR(F4)=YEAR(TODAY()),"Outstanding","Current")))

 

[Norie]

Try this.

=IF(ISBLANK(F4),"",IF(F4<TODAY(),"Overdue",IF(YEAR(F4)=YEAR(TODAY()),"Outstanding","Current")))

 

[Brentsa]

Thanks Fluff

How about

+Fluff New.xlsm
	E	F	G
4	01/01/2019	01/01/2020	Overdue
5	01/10/2019	01/10/2020	Outstanding
6	29/02/2020	28/02/2021	Current
Data

Cell Formulas
Range	Formula
F4:F6	F4	=EDATE(E4,12)
G4:G6	G4	=IF(E4="","",IF(F4<=TODAY(),"Overdue",IF(YEAR(F4)=YEAR(TODAY()),"Outstanding","Current")))

Problem Solved

 

[Fluff]

Glad we could help & thanks for the feedback.