Help if possible.

[bgjon5]

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

[VBA Noob]

Hi,

Not sure why you want to mox days with $ but this should do the trick

=IF(C1-A1+1>=15,TEXT((C1-A1+1)*15,"$###,###"),TEXT(C1-A1+1,"###,###")&" Days")

I added Days and $ text so you can tell which is which

VBA Noob

[Roger Govier]

Hi

Your answer was correct, it is just the formatting of cell C1.
Format>Cells>General and your result of 1/01/1900 will show as 1

In cell D1
=IF(C1>=15,C1*15,"")
Format the cell as Currency

--
Regards

Roger Govier


"bgjon5" <bgjon5.2b1wws_1153075212.6563@excelforum-nospam.com> wrote in
message news:bgjon5.2b1wws_1153075212.6563@excelforum-nospam.com...
>
> 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
>

[VBA Noob]

Roger

I agree he needs to seperate the two formulas into two columns to make any sense.

VBA Noob

[bgjon5]

Hi,

Not sure why you want to mox days with $ but this should do the trick

=IF(C1-A1+1>=15,TEXT((C1-A1+1)*15,"$###,###"),TEXT(C1-A1+1,"###,###")&" Days")

I added Days and $ text so you can tell which is which

VBA Noob

Sorry maybe I confused you

I want to show a dollar value after the total of days but I only need the value to multiply after 15 days for instance

the trailer came in on 6/30/06 its now 7/16/06 so 16 days have went buy so the total would be $15 then tomorrow it would be $30 and so on

also I ran into another problem but I'll wait to ask that LOL.. sorry guys if I am being a pain.

[VBA Noob]

Try this

=IF(C1-A1+1>15,TEXT(((C1-A1+1)-15)*15,"$###,###"),TEXT(C1-A1+1,"###,###")&" Days")

VBA Noob

[bgjon5]

Try this

=IF(C1-A1+1>15,TEXT(((C1-A1+1)-15)*15,"$###,###"),TEXT(C1-A1+1,"###,###")&" Days")

VBA Noob

God your good!

Bows down LOL

works perfect Thanks !