Posted in: Software
comb asked:
Ex: I have 1/4/2004 in one cell and 6/4/2009 in another. I want to write a formula that will tell me how many March’s there were between those dates. (or January’s, February’s, September’s, etc…)
Ex: I have 1/4/2004 in one cell and 6/4/2009 in another. I want to write a formula that will tell me how many March’s there were between those dates. (or January’s, February’s, September’s, etc…)
May 9th 2009
One way you could do it is use the MONTH() function to get out the month of any date. So, in a separate column, I could write:
=IF(MONTH(cell)=3, 1, 0)
Then every time the month is March, the cell will return a 1. Then add all the ones, and you should be done!
May 10th 2009
Let’s say your dates are in cells A1 thru A40. Put the following formula in an adjacent cell somewhere.
=SUMPRODUCT(–(MONTH(A1:A40)=1))
The “1″ at the end represents January. Change it to 2 for counting February. Change it to 3 to count for March. Etc