Posted to microsoft.public.excel.misc

David Biddulph[_2_] David Biddulph[_2_] is offline

external usenet poster

Posts: 8,651

Dates in different formats

If the dates are in A1 and B1 respectively, the formula is
=DATEDIF(A1,DATE(LEFT(B1,4),1,0)+RIGHT(B1,3),"m")
--
David Biddulph

"GARY" wrote in message
...
How do I compute the number of months between a date in the mm/dd/ccyy
format (such as 03/12/2002) and a date in the Julian date format (such
as 2009341)?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Dates in different formats	Pete_UK	Excel Discussion (Misc queries)	0	December 8th 09 09:31 AM
Converting dates to different formats	Nelson B.	Excel Discussion (Misc queries)	5	September 2nd 09 03:03 PM
several conditional formats for dates	Dana	Excel Discussion (Misc queries)	4	February 19th 09 04:37 PM
dates and formats	Jenny dev	New Users to Excel	1	July 21st 08 04:03 PM
Converting US Dates to UK Formats	Matt	Excel Worksheet Functions	4	July 13th 06 02:52 PM

All times are GMT +1. The time now is 11:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us