dates and formulae

[geepeetee]

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]

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