Formula To Checking Date Between or Equal Start & End date Then Give 'Ok' or 'Late'

[muhammad susanto]

hi all..

how to solve this date problem

Book1
	E	F	G	H
1	start date	end date	input date	Expected Result
2	01/12/2022	06/12/2022	06/12/2022	ok
3	01/02/2023	05/02/2023	06/02/2023	late
4	01/03/2023	04/03/2023	02/03/2023	ok
5	01/04/2023	05/04/2023	05/04/2023	ok
6	01/05/2023	04/05/2023	05/05/2023	late
7	01/06/2023	05/06/2023	07/06/2023	late
Sheet1

in col. 'input date is manually entry date..
with criteria , if date input between or equal start date & end date so the result is ok but otherwise is late
my format date in (dd/mm/yyyy)
my target in col H2 down

anyone help, thanks in advance

susant

 

[FormR]

Hi, here's one option you can try:

Book5
	A	B	C	D
1	start date	end date	input date	Expected Result
2	01/12/2022	06/12/2022	06/12/2022	ok
3	01/02/2023	05/02/2023	06/02/2023	late
4	01/03/2023	04/03/2023	02/03/2023	ok
5	01/04/2023	05/04/2023	05/04/2023	ok
6	01/05/2023	04/05/2023	05/05/2023	late
7	01/06/2023	05/06/2023	07/06/2023	late
Sheet1

Cell Formulas
Range	Formula
D2:D7	D2	=IF(MEDIAN(A2:C2)=C2,"ok","late")

 

[muhammad susanto]

hi FormR, wowwwww thank you, it working well.