View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Calculating days since a particular event

=B1-A1

format as general


--


Regards,


Peo Sjoblom



wrote in message
...
Is there a way to automatically calculate days since a particular date
(event)?
For example, if X event (in column A) happened on 1/1/06 and Y event
(in column B) happened on 10/14/07, how do I make column C = the
number of days between X and Y (column A and B)?

Thanks