Need formula to distinguish is task date is due within the month

[victoriar]

Hello, I need a formula to identify if the task dates that have been entered are either "Past due", "Not due this month", or "Yes, due this month"
A little context, our Program Managers have monthly tasks that need to be completed each month. Program Managers input the dates within that month.

For example, for June 2024, all Program Mangers will enter June 2024 dates for different tasks. I would like help with generating a formula to indicate whether within the month of June 2024 the dates state "Past due", "Not due this month", or "Yes, due this month". We have 6 month authorizations and put future dates so that should reflect "Not due this month" and if dates within June should say Yes due this month. Etc.

This is what I have so far, I just cant figure out how to make a formula to say whether within the month of June it says "Yes, due this month".
=IF(C25="","Not due this month", If(C25<Today(),"Past due",IF(C25>Today(), "Not due this month")))

 

[etaf]

As you already have <today and > this month
then try

=IF(OR(C25="",C25>EOMONTH(TODAY(),0)),"Not due this month",IF(C25<TODAY(),"Past due","Due this month"))

Book1
	A	B	C	D
24
25				Not due this month
26			1/1/24	Past due
27			6/1/24	Past due
28			6/6/24	Due this month
29			7/1/24	Not due this month
30			6/3/24	Due this month
Sheet1

Cell Formulas
Range	Formula
D25:D30	D25	=IF(OR(C25="",C25>EOMONTH(TODAY(),0)),"Not due this month",IF(C25<TODAY(),"Past due","Due this month"))
C30	C30	=TODAY()