Can I us a wildcard as the day portion of a date in an IF statemen

[JR]

I have an IF statement where I am looking to see if a date falls in the month
of July 2004. Is there a way to use a wildcard to say:

=IF( D2<=DATEVALUE("07/**/2003"),E2," ")?

If it is ANY day within July, I want it to be TRUE. I know I can say if the
date is > 7/1/2004 and then nest another IF statement to say of the date is <
8/1/04 but the actual formula is quite large so I want to keep this simple
if I can.

 

[Frank Kabel]

Hi
one way:
=IF(TEXT(D2,"MMYYYY")="072003",E2,"")

 

[Don Guillett]

You could always use
year(2003)
month(7)

 

[Dave R.]

You can use

=IF(AND(MONTH(D2)=7, YEAR(D2)=2003),E2,"")

 

[Arvi Laanemets]

Hi

=AND(MONTH(D2)=7,YEAR(D2)=2003)

In case the year isn't significant, then you can simplify it:
=(MONTH(D2)=7)


Arvi Laanemets