Convert string to date

A

Arne Hegefors

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weekdays 5
Macros to convert Data into date format and then plot in graph 7
Convert a yyyymmdd date format in code 4
Need help in converting text string based date to excel date format 2
Convert Date-as-Text 3
VBA Code to create reminders in Outlook from Excel 0
date corruption? 00/01/1900 2
Add-in WITH worksheets?? 1

Top