Count days between text dates
Well, that's good to hear, Benny - thanks for feeding back.
Pete
On Aug 11, 5:30*pm, Benny wrote:
It works thanks. *You just saved me about 30 minutes per day everyday.
"Pete_UK" wrote:
Assuming the earlier date is in A1 and the later date in B1, put this
in C1:
=DATEVALUE(MID(B1,5,LEN(B1)-9)&"-"&LEFT(B1,3)&"-"&RIGHT(B1,4))-
DATEVALUE(MID(A1,5,LEN(A1)-9)&"-"&LEFT(A1,3)&"-"&RIGHT(A1,4))
It returns 415 for your example data.
Hope this helps.
Pete
On Aug 11, 4:18 pm, Benny wrote:
Hello, I need to count the number of days between dates also the months are
in spelled out. *I can't change them to numbers. *So, is there a way to count
days if cell A1 is Sep/5/2008 and cell B1 is Oct/25/2009?- Hide quoted text -
- Show quoted text -
|