validating dates?

[Guest]

Hi all

I need to create a way of validating a spreadsheet so that it will show if a date is entered in the field. Is this possible? I was thinking it will be an IF statement but that is as far as I have got. Any suggests would be greatly appreciated.

kind regards

Gareth

 

[Andy Wiggins]

Data > Validation
In "Allow" select Date
Then select your Start Date and End Date, which can also be formulas, for
example, =Now()+30

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

Hi all

I need to create a way of validating a spreadsheet so that it will show if

a date is entered in the field. Is this possible? I was thinking it will be
an IF statement but that is as far as I have got. Any suggests would be
greatly appreciated.

 

[Guest]

Hi Andy

The method you suggest is very useful but I dont think I can use it at the moment as I want to validate dates that have already been inputted to check they are dates.

I tried creating a validation column but it does not respond with cut and paste.

 

[JulieD]

HI rexmann

i answered your very similar question to this in the other forum, but you
can also use data validation to validate data that has already been entered
so that might be another approach you could take,

select the cells, choose data / validation and choose Date under the allow
set a range that is valid for what dates you have (1/1/1990 to 31/12/2005)
or whatever
and then click OK

now from the menu choose
tools / formula auditing / show formula auditing toolbar (i think this is
the 2002/2003 name for it, but you should find it under auditing or similar)
on the toolbar is circle invalid data icon which will circle anything on the
sheet that doesn't meet your data / validation setting

hope this helps
cheers
JulieD

Hi Andy

The method you suggest is very useful but I dont think I can use it at the

moment as I want to validate dates that have already been inputted to check
they are dates.