Hi all,
I am using VBA to format a date and it worked fine, but just decided to stop working it seems!
The code I have is this:
DateVal = Format("01-" & Ind.Cells(2, 4).Value, "mmmm")
The value of Ind.Calls(2, 4) will be either Jan/Feb/Mar/etc...
And I want it to be formatted as January..any ideas why this doesn't work or any other way of doing it?
I know I could just use an index/match or vlookup on a table that has Jan-January, etc...
Any help would be welcome.
cheers,
Eoin
I am using VBA to format a date and it worked fine, but just decided to stop working it seems!
The code I have is this:
DateVal = Format("01-" & Ind.Cells(2, 4).Value, "mmmm")
The value of Ind.Calls(2, 4) will be either Jan/Feb/Mar/etc...
And I want it to be formatted as January..any ideas why this doesn't work or any other way of doing it?
I know I could just use an index/match or vlookup on a table that has Jan-January, etc...
Any help would be welcome.
cheers,
Eoin