If date in cell occurs between 2 dates

[djaldente]

Hi,

I need a formula to determine whether a date listed in an adjacent column occurs between the 1st and the 15th of the current month or the 16th and the 31st of the current month.

Thanks in advance

 

[Peter_SSs]

Is this what you mean?

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

20 11 16.xlsm
	B	C
1	Date	Result
2	25-Nov-20	Second half
3	13-Nov-20	First half
4	25-Oct-20	N/A
5	01-Dec-20	N/A
6	05-Nov-18	N/A
7	16-Nov-20	Second half
Check date

Cell Formulas
Range	Formula
C2:C7	C2	=IF(TEXT(B2,"my")=TEXT(TODAY(),"my"),IF(DAY(B2)<16,"First half","Second half"),"N/A")

 

[djaldente]

Is this what you mean?

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

20 11 16.xlsm
	B	C
1	Date	Result
2	25-Nov-20	Second half
3	13-Nov-20	First half
4	25-Oct-20	N/A
5	01-Dec-20	N/A
6	05-Nov-18	N/A
7	16-Nov-20	Second half
Check date

Cell Formulas
Range	Formula
C2:C7	C2	=IF(TEXT(B2,"my")=TEXT(TODAY(),"my"),IF(DAY(B2)<16,"First half","Second half"),"N/A")

Thanks Mate,

That is pretty much it, though its actually any month not the current month.

My apologies, cheers

 

[Peter_SSs]

That is pretty much it, though its actually any month not the current month.

Ah, I was misled by ..

between the 1st and the 15th of the current month

.. but anyway, you just needed a snippet of that formula by the sound of it?

=IF(DAY(B2)<16,"First half","Second half")

 

[djaldente]

Ah, I was misled by ..

.. but anyway, you just needed a snippet of that formula by the sound of it?

=IF(DAY(B2)<16,"First half","Second half")

Yea I know, sorry mate.

Thanks very much

 

[Peter_SSs]

No problem. All good in the end.