Hi -

Please forgive my ignorance but I just don't know anything about Excel. I
have an expense report that I have to file monthly that has to show daily
mileage for both company and personal mileage. I want to automate the
functions as much as I can as an aid to ensuring accuracy. Each day has its
own line and data with totals for the data at the bottom. Here are my
questions:

1) How do I get the current date to automatically load into the appropriate
cell? In other words, when I open this file daily how do I get the current
date to appear in the cell but still retain the option of changing it in case
I forget to update daily.

2) The report asks for beginning and ending odometer readings. I'd like to
be able to just input that data and have the 'daily mileage' show up
automatically. One caveat is that if I have any personal miles for that
particular day, the business mileage should be decreased by that amount. I'd
like to have this in the computation also.

3) In accordance with all of this, the monthly total (on a daily basis)
should be incremented by the daily figures.

Thank you in advance for your assistance. It's greatly appreciated.

Farquhardt