M
mmay321
I am creating a log that keeps track of how many of a certain produc
are sold within the month. The product is always sold one at a time, s
i just need a formula that can will look at the date column and repor
how many entries fall within the given month. The date is entered i
the following format: mm/dd/yy. I have tried using the COUNTI
function:
=COUNTIF(log!A2:log!A3000, CRITERIA)
However, I do not know how to set up the CRITERIA to calculate al
dates within a month, since the dates are not entered just as month an
year, but include the day
+-------------------------------------------------------------------
|Filename: Z-Gun SN Log.zip
|Download: http://www.excelforum.com/attachment.php?postid=3677
+-------------------------------------------------------------------
are sold within the month. The product is always sold one at a time, s
i just need a formula that can will look at the date column and repor
how many entries fall within the given month. The date is entered i
the following format: mm/dd/yy. I have tried using the COUNTI
function:
=COUNTIF(log!A2:log!A3000, CRITERIA)
However, I do not know how to set up the CRITERIA to calculate al
dates within a month, since the dates are not entered just as month an
year, but include the day
+-------------------------------------------------------------------
|Filename: Z-Gun SN Log.zip
|Download: http://www.excelforum.com/attachment.php?postid=3677
+-------------------------------------------------------------------