Conditional Formula Needed

[fishin]

Completion Dates appear in column Y13 thru Y298. Cells are formatted as: “Date” Type - *3/14/2001

Schedule Dates appear in column AC13 thru AC298. Cells are formatted as: “Date” Type- 3/14/01
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Problem 1: I want to sum the number of cells in Y13 thru Y298 wherein the date that appears is within the month of February of 2011 and do so only when the date that appears in corresponding cells AC13 thru AC298 is also within the month of February of 2011.

Problem 2: I want to sum the number of cells in Y13 thru Y298 wherein the date that appears is within the month of February of 2011 and do so only when the date that appears in corresponding cells AC13 thru AC298 does not equal the month of February of 2011 or is blank.

 

[bryonwoods30]

for problem 1 in z13 you could use the formula
=IF(AND(MONTH(Y13)=2,MONTH(AC13)=2),"1")

then use the count function to count all the 1's you get in column z.

for problem 2 in aa13 you could could then just subtract the value from your first count from the total