If formula issue with date

Dear Excel Experts,
Greetings,

Kindly appreciate your help with a formula that allow me to compare an IF formula with Today Date, for more info. kindly check the attached file or check the link below.
https://ufile.io/msot6r41

Hi there,

I may have misunderstood your requirements, but try entering the following formula in Cell D2 and copying it downwards:

Please Login or Register  to view this content.

The formula calculates the last day of the month for the date specified in Cell C2, and displays the "Will expire" message if the last day of that month is one day before the date specified in Cell J3.

You'll need to enhance the formula if there's a possibility that "whatever it is" has already expired.


Hope this helps.

Regards,

Greg M

not working as expected Greg M.. kindly read my attachment
its close to this formula but i need to fix it
=IFERROR(IF(DATE(RIGHT(Y10;17);MID(Y10;5;2);LEFT(Y10;0))<=DATE(RIGHT($Y$6;4);MID($Y$6;3;2);LEFT($Y$6+0));$B3;"");"")

Originally Posted by JeteMc

The formula in post #3 doesn't seem to relate to the file in post #1 as there is nothing in column Y in the file.
Perhaps the better strategy would be to manually show the expected results, I assume in column D, so that we have something with which to compare the output of our proposed formulas/code.
Let us know if you have any questions.

In the formula i added you can change Y10 to C2 while the formula will be added and start from D2..
THANKS ALOT FOR YOUR HELP

Need to fix and organize the date (month and year) from the text in this formula

=iferror(if(date(right(c2;17);mid(c2;5;2);left(c2;0))<=date(right($y$6;4);mid($y$6;3;2);left($y$6+0));$b3;"");"")

Originally Posted by JeteMc

Since the date in cell J3 includes the day I feel that the formula in column D that references the dates in column C should include days also.
Here is a modification of the formula from post #6 that returns all of the names in column B: =IFERROR(IF(DATE(LEFT(C2;4);MID(C2;9;2);MID(C2;6;2))<=J$3;B2;"");"")
The date in J3 is June 1, 2026, if the day from is not important then the formula could be written: =IFERROR(IF(DATE(LEFT(C2;4);MID(C2;9;2);1)<=J$3;B2;"");"")
It would be helpful to know what is expected to be in cell D2:D6.

thanks alot bro, it works