Thread: Subtract Date Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default 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?