Subtract Date Q
 

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?

Subtract Date Q
 

Have you tried looking in the help index for DATE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sean" wrote in message
...
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?

Subtract Date Q
 

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?

Subtract Date Q
 

Either:

=date(2008,1,28)-date(2008,1,25)
or
="28/01/08"-"25/01/08"

Regards,
Fred

"Sean" wrote in message
...
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?