If you want the answer in months, then use the DATEDIF function,
described he

http://www.cpearson.com/excel/datedif.aspx

Hope this helps.

Pete

On Apr 23, 9:22*am, 3R wrote:
How to calculate duration? For example 1 April 08 to 30September 2008 - how
many months