Help if possible.
 

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

Help if possible.
 

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


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

Help if possible.
 

Hi

Your answer was correct, it is just the formatting of cell C1.
FormatCellsGeneral 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" wrote in
message ...

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

Help if possible.
 

Roger

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

VBA Noob


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

Help if possible.
 

VBA Noob Wrote:
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.


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

Help if possible.
 

Try this

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

VBA Noob


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

Help if possible.
 

VBA Noob Wrote:
Try this

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

VBA Noob


God your good!

Bows down LOL

works perfect Thanks !


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