[ExcelVBA] countif and date

 

I have a problem maybe someone here can help me out with. I am working with a 2 sheet workbook. sheet 1 has my data that has a date in column one. I want to create a graph for the current month on all activity with the current month. I am thinking on using Month() in the countif formula like below. I cant get any thing to work.

=COUNTIF(month(ACTION!A2:A300),"month(NOW())") does not work
=COUNTIF(ACTION!A2:A300,"MONTH(NOW())") does not work
=COUNTIFS(ACTION!$A$2:$A$298,">12/31/2011") works but need current all the time with out my intervention

=MONTH(ACTION!A4) works by its self
=IF(NOW()=Reports!A4,1,2) works by its self

I need to use the countif formula for my graph and to make it real time.
Any idea would be greatly appreciated.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 10

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___