How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
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...!
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...!