Due date closed based in the new row entry

[bwarodri]

Hi there,

I´m trying to figure out a way to have a formula that update the status of one row line (from "overdue" to "completed") based in a new entry, sending an example below.

Activity	Last Date	Next Date	Status
A	01/01/2022	31/01/2022	Overdue
B	10/02/2022	12/03/2022
C	05/05/2022	04/06/2022
D	02/06/2022	02/07/2022
A	31/01/2022	02/03/2022

 

[Legacy 143009]

Paste this to D2 and drag down:

=IF(COUNTIF(A2:A$6,A2)=1,"Overdue","Completed")

 

[bwarodri]

Paste this to D2 and drag down:

=IF(COUNTIF(A2:A$6,A2)=1,"Overdue","Completed")

Dear Flashbond, many thanks for the prompt reply. Work perfectly.