| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
