Check out:
http://tinyurl.com/28kcfq
http://www.cpearson.com/excel/datetime.htm
HTH,
JP
On Jan 28, 10:35*am, Sean wrote:
How do you subtract 2 dates within a formula?
eg =(28/01/08)-(25/01/08)
I know if A1= 28/01/08 and B1= 25/01/08 I could enter =A1-B1. But if I
wish just to hard code within a formula these values.
How does one do that?