Date Help

[How_Do_I]

Can anyone help with this please... My cell contains the following:

Date: 1916/10/01-1916/11/30

What I'd like please is a formula for Start Date - End Date. So the expected return would be 01/10/1916 in one cell and 30/11/1916 in the next cell.

I have lots of these to convert and the only potential hiccup that I can see is, in some the dates go from one year to the next. Might be a problem for the solution, might not be...!

 

[etaf]

is the format allways
1916/10/01-1916/11/30

you can use LEFT() and RIGHT()
I have changed the cell format to display as DD/MM/YYYY - just to see date is real
Although the Mac I have and XL2BB changes the format to MM/DD/YY

lookup 2 criteria 1 to Nearest Greater Value.xlsx
	A	B	C
1	1916/10/01-1916/11/30	10/1/16	11/30/16
Sheet3

Cell Formulas
Range	Formula
B1	B1	=LEFT(A1,10)*1
C1	C1	=RIGHT(A1,10)*1

 

[How_Do_I]

That's much easy than I was thinking... Thanks etaf...

 

[etaf]

you are welcome