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

Thread: [Solved] Need a date formula

View Single Post

Old

08-11-2010, 04:05 AM

nsv

nsv is offline

nsv uses Windows XP

Windows XP nsv uses Office 2003

nsv uses Office 2003

Office 2003

Novice

Join Date: Jul 2010

Location: Denmark

Posts: 17

nsv is on a distinguished road

Default

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

Reply With Quote