Posted to microsoft.public.excel.worksheet.functions

newbie

external usenet poster

Posts: 137

Date Subtraction

I am trying to take a later date and subtract from it an earlier date to
determine the time in between. (07/11/06)-(04/14/05)=(03/28/01)
1Y 3M 28D is not correct. What am I missing?

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
date subtraction	[email protected]	Excel Worksheet Functions	6	December 9th 08 02:13 PM
Different results: Networkdays versus date subtraction	OxonLad	Excel Worksheet Functions	6	June 18th 08 03:38 PM
Subtraction	Rookie	Excel Worksheet Functions	14	February 24th 08 11:42 AM
date and time in 2 cells to create subtraction in 3rd	MikeR-Oz	New Users to Excel	2	October 27th 07 10:35 AM
Date subtraction -How to not show negative when 2nd date not entered	Edward[_2_]	New Users to Excel	2	September 27th 07 03:03 PM

All times are GMT +1. The time now is 08:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us