Posted to microsoft.public.excel.misc

jude

external usenet poster

Posts: 16

How do I subtract dates to get a number in years or years & month

Say I wanted to subtract 1/01/2005 from 6/30/2006 where I would get 1.5
years. Anybody know?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
holiday dates	bucci	Excel Worksheet Functions	4	June 15th 06 09:35 AM
Dates - Months & Years	Rick	Excel Worksheet Functions	5	November 23rd 05 04:11 PM
Find the number of years between two dates	duke	Excel Discussion (Misc queries)	2	September 10th 05 03:56 AM
Total number of each month in a column of dates	GeorgeF.	Excel Worksheet Functions	1	November 19th 04 06:10 PM
Convert week number into calendar month?	WickyWick	Excel Worksheet Functions	2	November 9th 04 09:01 PM

All times are GMT +1. The time now is 04:36 PM.

About Us

"It's about Microsoft Excel"