Sorry if this is posted in the wrong fourm but heres what I am trying to
do:

I need to set up a spreadsheet, i've got the basics down (I think) but
am having some problems what i am trying to do is:

I need to track how long a for intance a trailer has been in my yard so
I set up a basic spread sheet with dates say in A1 I have the date the
trailer comes in say 7/15/06 and then I need a automatic function to
add a current date everytime I open the sheet again, say in like C1 and
I need the dates to subtact eachother so if I open it today (7/16/06) it
will show 1 (as the number of days its been here) i set up a =Today()
macro but it won't let me subtract from it it keeps giving me like
1/01/1900 or something..

I hope this isn't too confusing.....

and after 15 days I need it to start multiplying by $15 . If you can
help it would be appreciated if not just tell me to bug off LOL.


Jon


--
bgjon5
------------------------------------------------------------------------
bgjon5's Profile: http://www.excelforum.com/member.php...o&userid=36410
View this thread: http://www.excelforum.com/showthread...hreadid=561866