Need a date formula

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

FAQ

Thread Tools

Display Modes

08-11-2010, 04:05 AM

nsv

Windows XP Need a date formula

Office 2003

Novice

Join Date: Jul 2010

Location: Denmark

Posts: 17

That solution gives you one whole year between Dec. 31st and Janury 1st even though there is only one day between them, so perhaps you should also try:

Code:

 
=ROUND((A2-A1)/365.25,0)

NSV

« Previous Thread | Next Thread »

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 06:54 PM.