Help if possible.

  • Thread starter Thread starter bgjon5
  • Start date Start date
B

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
 
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
 
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
 
Roger

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

VBA Noo
 
VBA said:
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
Click to expand...
Sorry maybe I confused you

I want to show a dollar value after the total of days but I only nee
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 bu
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.. sorr
guys if I am being a pain
 
Try this

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

VBA Noo
 
Back
Top