|
PureBytes Links
Trading Reference Links
|
You can also use the DateDiff function to do date arithmetic.
Earl
----- Original Message -----
From: "ketayun" <ketayun@xxxxxxxxxxxxx>
To: <realtraders@xxxxxxxxxxxxxxx>
Sent: Wednesday, September 24, 2003 10:11 AM
Subject: Re: [RT] calender dates
> > 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
>
>
> Thank you, Thank you, Thank you :-) .
>
> Good Trading,
>
> Kate
------------------------ 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/
|