Need a date formula

		Microsoft Office Forums > Microsoft Excel > Excel
Need a date formula

08-10-2010, 07:43 AM

mugezhn

Windows XP Need a date formula

Office 2007

Novice

Join Date: Jul 2010

Posts: 16

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

=YEAR (A2)-YEAR(A1)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
date in forms	gilgold	Word	2	05-28-2010 01:19 PM
Julian Date	windseaker	Excel	1	02-14-2010 01:44 AM
new appointment date always reverts back to today's date	msills	Outlook	0	08-24-2007 08:57 AM
Date format always interpreted as a formula	Butch Jackman	Excel	1	02-14-2006 11:27 AM
Imported message date change to today's date	promark	Outlook	1	12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:22 AM.