Validate dates entered in excelsheet

[itsmaheshp]

Hai guys,
I have to prepare an excel sheet which resembles the 'Timesheet form
(seen in big companies which is to be filled by employees at the end o
month).user has to select the month and year first and then he has t
enter the total no.of hrs worked from day1 to end of month like this.
if he has selected say 'October' '2004'
date Hrs
-----------------
10/01/04 5
10/02/04 5
.......goes like this

here i have to validate in the excel sheet that if user has entere
wrong date or different month like 11/01/04, it has to display erro
message.
how i have to achieve this.....
plz help me
Thanks & regards,
Mahesh

 

[Guest]

Hi
use 'Data - Validation - Date' for this