Posted to microsoft.public.excel.misc

Shannan

external usenet poster

Posts: 41

Subtracting dates from two columns

Hi,
I am trying to find a formula that will subtract the dates from two columns
and give me the difference in months. I had " =MONTH(AD15)-MONTH(Y15)", but
i've just realized that if one date is 2007-09-08 and the other is
2006-11-27, then the formula i was using does not account for the years being
different and gives me an answer of -2. How do i account for the years?
Thanks.

Shannan

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
Subtracting Dates	Terry Bennett	Excel Worksheet Functions	7	November 17th 07 11:38 AM
Subtracting Dates	Malik	Excel Discussion (Misc queries)	4	October 1st 07 10:44 AM
Subtracting dates	toot033	Excel Discussion (Misc queries)	3	July 17th 06 09:03 PM
Subtracting dates?	Bill R	Excel Worksheet Functions	1	August 15th 05 05:37 AM
Subtracting dates: 8/31/05-8/1/05?	dstock	Excel Discussion (Misc queries)	1	July 26th 05 04:04 PM

All times are GMT +1. The time now is 02:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us