Microsoft Office Forums - View Single Post - [Solved] Need a date formula

Thread: [Solved] Need a date formula

View Single Post

Old

08-10-2010, 07:43 AM

mugezhn

mugezhn is offline

mugezhn uses Windows XP

Windows XP mugezhn uses Office 2007

mugezhn uses Office 2007

Office 2007

Novice

Join Date: Jul 2010

Posts: 16

mugezhn is on a distinguished road

Default

Asumming the dates are in cells A1 and A2 respectively, you can use the following formula:

=YEAR (A2)-YEAR(A1)

Reply With Quote