Formula for Overdue based on > and < date

[rajeshm28]

Good Day,

I have the below formula where the workday formula would return the 15th of a month.

What i am looking for is to update the cell with Overdue if the date range falls between >=15 and <=20 of the any given month.

=IF(TODAY()>=15,"Overdue",WORKDAY.INTL(EOMONTH(EDATE(TODAY(),1),-1),13,11))

please help.

 

[Asbestos_Jen]

Try this:

IF(AND(TODAY()>=15,TODAY()<=20),"Overdue",WORKDAY.INTL(EOMONTH(EDATE(TODAY(),1),-1),13,11))

 

[rajeshm28]

Try this:

IF(AND(TODAY()>=15,TODAY()<=20),"Overdue",WORKDAY.INTL(EOMONTH(EDATE(TODAY(),1),-1),13,11))

thank you, i tried to change today()<=30 and EOMONTH(EDATE(TODAY(),1),-2) to reflect current month but it did not give me overdue as output.

 

[Fluff]

How about

=LET(d,TODAY(),IF(AND(DAY(d)>=15,DAY(d)<=20),"Overdue",WORKDAY.INTL(EOMONTH(EDATE(d,1),-1),13,11)))

 

[rajeshm28]

How about

=LET(d,TODAY(),IF(AND(DAY(d)>=15,DAY(d)<=20),"Overdue",WORKDAY.INTL(EOMONTH(EDATE(d,1),-1),13,11)))

I only get the output as 15-10-2024 and not as overdue

 

[Asbestos_Jen]

Can you explain in words what your formula is supposed to do? The formula you gave in post #1 checks if today is greater or equal to than 15, which will always be true, because 15 as a date = Jan. 15, 1900. Today will never be less than or equal to 30, since that is Jan. 30, 1900.

​

 

[Fluff]

I only get the output as 15-10-2024 and not as overdue

That's because today is not between the 15th & the 20th.

 

[rajeshm28]

That's because today is not between the 15th & the 20th.

i got it. i tried to change d)>=25,DAY(d)<=30 and it displayed overdue, thank you so much.

 

[Fluff]

Glad we could help & thanks for the feedback.