[ExcelVBA] Excel Date Calculations

 

Hi,
 
I have an Excel sheet for which I am calcuating the number of items in a particular field (Verification) on a daily basis to develop a trend chart.  I would also like to have this update on a real time basis based on the current date - to which, I am using the following formula:
 
=SUMPRODUCT(('Verification Items'!$D:$D="Verification")*(IF(TRUNC('Daily Comp Count'!U2)=TRUNC(TODAY()),"1","0")))
 
(The "Daily Comp Count" worksheet has dates all along the top in row 2 - hence, I'm seeing if (in this case) U2 is today and if so, make it a 1 and multiply it with the number of items in "Verification").
 
This is working fine for the current day, but when tomorrow comes, the values for the previous date will turn back to zero - is there any way that I could prevent this from happening (i.e. the values remain even when the date changes)?
 
Thanks...........

[Non-text portions of this message have been removed]

__._,_.___

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

Messages in this topic (1)

Recent Activity:

• New Members 9

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

.

__,_._,___