Validating a date in Excel 97

[mooneye]

I am trying to validate date fields.
I need to flag a date if it is less than todays date by 14 days.
Regards
mooneye

 

[Rhort]

You could use a 'Conditional Format' to set the target dates to bold text:

Select the range you want to check, then select 'Conditional Formatting' from the 'Format' menu. Create a condition where:

First box reads: Cell value is
Second box reads: Less Than
Third Box reads: =Today()-14
Click on the 'Format' button and select 'Bold' from the Font Style dialog.

Click 'Ok', then 'Ok' again. This will cause any date in the selected range that is more than 14 days ago to become bold. You could format this in any way, bold/italic/different font, etc.

 

[Dreamboat]

Validate? Do you mean you do not want to allow entry if the date entered is more than 14 days ago, or do you want the conditional formatting mentioned above?

http://www.TheWordExpert.com

 

[mooneye]

Conditional Formatting as above, I was only thinking of Validation as a means of flagging the date using the red circle to show what has become overdue by 2 weeks.

 

[DaleWatson123321]

mooneye,

If it happens that your application is one where you have, in effect, a "database", then perhaps you should consider setting up an "extraction" of those records overdue by 2 weeks.

This can VERY easily be attached to a "button", which when clicked, would extract the data, provide totals, and set the extracted data range for printing if desired.

If you like, I could send an example file, or another alternative would be for you to send me your file, and I'll attach the "button" and VBA code and return it.

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca