Dates in excell
The statement MyDate = (Mid$(fname, e, 8)) returns 8 characters from a
string in the format
JUL-2006
Excel is adding to that the day of the month so its returning the date
1/july/2006
I want it to default to the last day of the month and not the first, Is
there an easy way of doing it?
Thanks in advance.
Mike
|