Date Query - Look up or IF????????

  • Thread starter Thread starter nicknjohn
  • Start date Start date
N

nicknjohn

G'day

We are trying to write a function to work out if a date range (star
Date - Now) pass over a set of specific dates. If the date rang
crosses a 'Spot Date' then we need to return the result '1', if th
range passes 2 'Spot dates we need to return the result '2' and so on.

we have put the specific 'spot dates' into a table of their own t
'look up' to, but are scratching our heads furiously trying to find th
correct function to complete this task.

Any help would be appreciated.

John n Nic
 
Hi

If you are looking at a time from x to now, you only need to check if x is
before any of the spot dates. If your spot dates are in a list, you can do a
COUNTIF to return how many of them are bigger than (after) the start date.
 
Back
Top