Excel 2007 : 3 columns and auto adding

[roxy.roxy]

Totally new here and I need help!!

So...I am creating a tally sheet that will have 3 columns. They are "this date", "month to date" and "year to date"

Every day has a new number that needs to be added to the monthy total as well as the yearly total. How do I get it so that when I enter one number into the "this date" column it automatically adds to the monthy AND yearly columns?

I hope I am explaining this right. Currently my boss has this in Word format and I believe it will be much easier to enter into Excel if only I could figure it out!

I added the Word version so maybe you can look at it to understand what I mean. Thanks!