if formula help

[plost33]

i am wanting an if formula that will look at a cell and if the date in that is in the current month then it should return "yes" and return "no" if that date is not in the current month.

example:

cell A1 = 4/21/2011

this if formula is in cell A2. it should return "no" because 4/21/2011 is not in the current month of June 2011.

hope someone can help.

 

[arkusM]

Need to analysis Tool pak addin installed
=IF(AND(A1 > EOMONTH(Today(),-1),A1 < EOMONTH(Today(),0)),"yes","no")<EOMONTH(NOW(),0)),"YES","NO")<EOMONTH(NOW(),0)),"YES","NO")<EOMONTH(NOW(),0)),"YES","NO")[ CODE]<EOMONTH(NOW(),0)),?YES?,?NO?)< p>

 

[Aladin Akyurek]

i am wanting an if formula that will look at a cell and if the date in that is in the current month then it should return "yes" and return "no" if that date is not in the current month.

example:

cell A1 = 4/21/2011

this if formula is in cell A2. it should return "no" because 4/21/2011 is not in the current month of June 2011.

hope someone can help.

Try...

=IF(A1-DAY(A1)+1=TODAY()-DAY(TODAY())+1,"Yes","No")

This does not check whether there is a date in A1, but that can be added...

=IF(N(A1),IF(A1-DAY(A1)+1=TODAY()-DAY(TODAY())+1,"Yes","No"),"")

 

[Ron Coderre]

It's really important to post the version of Excel you're using so we can offer version compatible suggestions.

This regular formula works in all versions:

B1: =IF((A1-DAY(A1))=(TODAY()-DAY(TODAY())),"yes","no")

Does that help?

 

[arkusM]

Need to analysis Tool pak addin installed
=IF(AND(A1 > EOMONTH(Today(),-1),A1 < EOMONTH(Today(),0)),"yes","no")<EOMONTH(NOW(),0)),"YES","NO")<EOMONTH(NOW(),0)),"YES","NO")<EOMONTH(NOW(),0)),"YES","NO")[ CODE]<EOMONTH(NOW(),0)),?YES?,?NO?)< p>

Disregard this one. It fails on the last day of the month.

 

[plost33]

okay guys thanks. now to take it one step furthure:

if the date in A1 is no in the current month i want to return the first day of the current month....

 

[arkusM]

--------------

 

[Aladin Akyurek]

okay guys thanks. now to take it one step furthure:

if the date in A1 is no in the current month i want to return the first day of the current month....

Try...

=IF(A1-DAY(A1)+1=TODAY()-DAY(TODAY())+1,"Yes",TODAY()-DAY(TODAY)+1)

If you record today's date in a cell of its own, say, in E1...

=IF(A1-DAY(A1)+1=E1-DAY(E1)+1,"Yes",E1-DAY(E1)+1)

 

[plost33]

aladin, that does not seem to work. my date in a1 is 5/24/2011. this formula should return 6/1/2011 because it is the first day of the following month.

 

[plost33]

FORMULA IS CLOSE TO WORKING. IT IS JUST THE LAST PART THAT IS NOT. I NEED A FORMULA THAT WILL TAKE ANY DATE AND RETURN THE FIRST DAY OF THE NEXT MONTH. that is the final part i need to complete it.