Hi

Can i put in a formula to subtract one date from another and show the period
between in days, weekks or whatever. It is to calculate someones service
with the company. It is many different periods spanning 30 years.

thanks

Gary

Take a look at Chip Pearson's explanation of =datedif() at:
http://www.cpearson.com/excel/datedif.htm

geepeetee wrote:
>
> Hi
>
> Can i put in a formula to subtract one date from another and show the period
> between in days, weekks or whatever. It is to calculate someones service
> with the company. It is many different periods spanning 30 years.
>
> thanks
>
> Gary

--

Dave Peterson
(E-Mail Removed)