ExcelBanter - Dates in different formats

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Dates in different formats (https://www.excelbanter.com/excel-discussion-misc-queries/250421-re-dates-different-formats.html)

David Biddulph[_2_]

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)?

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