Help if possible.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bgjon5 - 16 Jul 2006 19:37 GMT

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

Signature

bgjon5

Reply to this Message

VBA Noob - 16 Jul 2006 19:52 GMT

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

Signature

VBA Noob

Reply to this Message

bgjon5 - 16 Jul 2006 22:00 GMT

VBA Noob Wrote:

> Hi,
>
[quoted text clipped - 6 lines]
>
> VBA Noob

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

Reply to this Message

VBA Noob - 17 Jul 2006 20:35 GMT

Try this

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

VBA Noo

Reply to this Message

bgjon5 - 17 Jul 2006 22:05 GMT

VBA Noob Wrote:

> 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

Reply to this Message

Roger Govier - 16 Jul 2006 21:14 GMT

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

Signature

Regards

Roger Govier

> Sorry if this is posted in the wrong fourm but heres what I am trying
> to
[quoted text clipped - 22 lines]
>
> Jon

Reply to this Message

VBA Noob - 16 Jul 2006 21:33 GMT

Roger

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

VBA Noo

Reply to this Message

Rate this thread: