Formula Help Please.

[kins]

Hi All,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
<o> </o>
I need a formula that looks at a date, ***** if it’s within a certain month, and if it is it counts it. E.g.
<o> </o>
A1 (expiry date) B1 (Reporting month date)
01/01/2011 January
01/02/2011 January
<o> </o>
<o> </o>
I need it to count line one but not line 2. Can anyone please help?
<o> </o>
<o> </o>
Thanks in advance,
<o> </o>
Kins
<o> </o>
<o> </o>
<o> </o>

 

[Joe4]

I don't think your question is quite clear. Both those dates appear to be in the same month, so why would one be counted and the other not be counted?

 

[kins]

ooops. sorry joe.


basically, i need it to look at a date, ***** if if within the reporting month and if it is put 1, if it's not, put 2.


01/01/2010 Jan (reporting month) - include
01/02/2010 Jan (reporting month) - exclude


does that make it clearer?

Thanks .

 

[Joe4]

I think you must be typing in something that is getting censored out, as both of your posts have "*****" (it may inadvertantly be identifying something and censoring it out). Can you try to say that part differently? If you click "Preview Post" before posting, you will be able to see if it will be censored out again.

Where is your reporting month defined?
Obviously, you want to compare these dates to a date range to see if they within these dates. Where is that defined/listed?

 

[jasonb75]

I think I get what you're asking

=SUMPRODUCT(--($B$1:$B$10=TEXT($A$1:$A$10,"mmmm")))

This assumes reporting month is"January", remove the last "m" if it's abbreviated to "Jan"

 

[kins]

sorry chaps. not thanked you for the above.

thanks, i'll give it a whirl now,


kins