How do I Trigger Fomulas on Specific Dates

[aspie]

Ref: http://www.excelforum.com/excel-gene...ml#post3819805

I have the same problem with a excel book that I am trying to design for maniging my finances. So far I havent put any data in to it, put it has been years since I used Microsoft Office and I used to be the one helping the teacher and the computer administrator lol.
So much for 4 computer qualifications, I am going back to do another computer course lol.

Can some one help me with this ?

I have sevral work sheets, the first being Expenditure. This is laid out with the first colum in the following format,
January
Week 1
Week 2
Week 3
Week 4
Febuary
Week 1
and so on all the way through the 52 weeks of the year, which for some reason ends in January.
The top row has varius catigories in it, Food, Cigaretes, Activities, Events, etc etc and and the month has a total as well as each of the 4 weeks.
I want these totals to calculate on the last day of each month, I would also like the totals of each month to be totaled on the last day of december and sent to the out goings sheet to to yearly out goings box, the monthly totals from the expenditure sheet would just be sent as they are on the last day of each month to the monthly out goings boxs. I would also like to connect my spread sheet with my bank account, but being autistic, im not aloud access to my bank account because of my learning difficulties I dont understand finance veryt well, I am just copying this spread sheet from things I have seen and memorised I am not entirley sure of the importance of it, but it will make my support workers happy.
If I can connect it to the bank I guess it would some how be possable to update the income sheet automaticaly with all my benifits information I could put another sheet in for bank transactions too
How would I go about doing that ? that would be so cool.

FYI

I have no understanding of Visual Basic

[protonLeah]

Your sample has no date values.

[newdoverman]

As a point of interest without solving your problem, this year the first week of January has only 4 days (1 - 4) and the same thing for December. The last week of December has only 4 days (28 - 31) that leaves January 2015 with Days 1 - 3 as the first week in 2015. So, the 53rd week of 2014 is week 1 of 2015.

protonLeah mentioned the lack of dates. Would the use of EOMONTH (end of month) be better to use in place of a week number that could end in the middle of a week?