Hi
I'm finally getting there...
Can anyone tell me how to convert a date (in standard dd/mm/yy format) to its equivalent Excel serial number? I'm trying to do an application.hlookup and it's only working if I enter the serial number directly rather than using the formatted date.
TIA
Danny
I'm finally getting there...
Can anyone tell me how to convert a date (in standard dd/mm/yy format) to its equivalent Excel serial number? I'm trying to do an application.hlookup and it's only working if I enter the serial number directly rather than using the formatted date.
TIA
Danny