Why does the sheet have TEXT in these cells? Use data validation to
check for date, and set the format of the cells to the format you want.
SamanthaK wrote:
Hi! I am writing a macro for a spreadsheet. You are supposed to write two
dates into the spreadsheet in two different cells. When a button is pressed
the program shall read the text in the cells and check to see if they are in
the right format e.g. 2006-06-14 and not 06-06-04 i.e. YYYY-MM-YY.
Help!!!!!!!!!!!
--
I am very thankful for any fast assistance!