Posted to microsoft.public.excel.misc

dlcroswell dlcroswell is offline

external usenet poster

Posts: 1

How do I create formula to calc difference in dates?

I have a 'hire date' & a 'term date'. I need to calcuate the difference in
months & don't want to do the calculations manually. EX. 7/1/06 1/1/06 = 6
months

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
what is the formula to show the difference between two dates	David	Excel Discussion (Misc queries)	1	July 27th 06 12:30 AM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Formula for calc diff between two julian dates	saltrm	Excel Discussion (Misc queries)	1	November 7th 05 08:00 PM
how do i put formula to find difference between two dates	A.D	New Users to Excel	3	May 12th 05 05:14 PM

All times are GMT +1. The time now is 05:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us