Hello all,
I am trying to get a cell to reset to zero at the end of the month. This sheet adds a value every day for a monthly/yearly total. On the first of every month the cell should be zero waiting for the new value for that day. Here is what I'm doing, d6=today's value, e6=monthly value, f6=yearly. Every day a new value gets put in d6 then that is added to e6 and f6 for a running total. How can I add a reset on date to the exsisting formula, (e6=d6+e6)?
Thanx
e6=d6+e6)?
Is red part of the formula correct?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fotis,
Yes it is correct although not sure if it's supposed to be that way.
I am quite sure that is not the correct way.
Pls, upload a small sample workbook.
Bulk
Shipments Type 1 Type I/II Type III Masonry Other
Day =Daily!I48 =Daily!J48 =Daily!L48 =Daily!M48 =Daily!N48
Month =$I$49+Production!I48
Year =I48+I50
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks