Convert string to date
 

Hi! I have a macro that prints a long series of dates on a worksheet. However
I cannot use these dates as proper dates in excel. Excel simply does not
understand that they are dates. Please help me solve this! Here is the code
when I print the dates (it is really in a loop but I left that code out).

Application.ThisWorkbook.Sheets("Settings").Cells( 6 + iq, 4) = strDate

Convert string to date
 

Application.ThisWorkbook.Sheets("Settings").Cells( 6 + iq, 4) =
datevalue(strDate)

"Arne Hegefors" wrote:

Hi! I have a macro that prints a long series of dates on a worksheet. However
I cannot use these dates as proper dates in excel. Excel simply does not
understand that they are dates. Please help me solve this! Here is the code
when I print the dates (it is really in a loop but I left that code out).

Application.ThisWorkbook.Sheets("Settings").Cells( 6 + iq, 4) = strDate