[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [RT] calender dates



PureBytes Links

Trading Reference Links

At 10:20 AM 9/24/2003, you wrote:

>Thanks for the suggestion. Are you saying that if day1 is today Sept. 
>6th. and I want to know the date  55 days forward/backward would be I 
>could do that? Or if I have 2 dates such as Sept. 6 and October 15th I 
>can calculate the difference in days and project that forward....?

Excel gives every date a number. Sept. 6, 2003 has the value 37870.

The date October 15 has the value 37910.

So if you subtract 9/6/03 from 10/15/03 you get 40.

Type in a date into a cell then format the cell as "Number". It will show the value for that date.

Bob Fulks




------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/zMEolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/