LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kane
 
Posts: n/a
Default Age & Time Restricted Validation dates ...

Birthdate in A43
Issue Date in G37
New Valid to Date ( ? ) in K37

Restrictions a
Age<40=12 months (to the 1st day of the following month)
Age40=6 months (to the 1st day of the following month)
Revalidation grace period=90 days prior to Valid to Date=normal Valid to Date
Revalidation prior to 90 day grace period=new Age <40 or Age40
Beyond Valid to date="Expired"

How would I set this up? There is a continuation to this, but thought we
could start from here.
Happy New Year , & in Rememberance!

.... Wayne


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation Window? Ken Excel Discussion (Misc queries) 1 January 11th 05 10:48 PM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 08:43 PM
entering numbers to display a time format Ian Williams/Eazygig Excel Discussion (Misc queries) 1 January 10th 05 11:57 AM
Help - Information with time and date PM Excel Discussion (Misc queries) 4 January 6th 05 08:25 AM
Date and Time Macro m.j.anderson Excel Discussion (Misc queries) 1 December 1st 04 12:35 AM


All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"