I am trying to work out a formula(s) that, on a daily basis identifies the
number of dates that are within 1 year (or 2 or 3 as desired), total, and
give a percentage overall. Those that do not conform within the time frame
have a conditional formatting to change colour (I can do this).
I am using this for a training qualification chart, to identify dates that
become unqualifed, and require the training again. This is also to assist in
corperate reporting, etc.
Bookmarks