View Single Post
  #6   Report Post  
Max
 
Posts: n/a
Default

Think what was suggested earlier wasn't that far off ..

The interp of your original set-up might have been a bit off earlier, though
<g. Think it was the flipped way around. If so, then the first response
should have read as:

Assume you have in D1:H1,
the "1st of month" dates formatted as "mmm-yy", viz.:
Jan-05 Feb-05 Mar-05 Apr-05 May-05

And you have *dates* in 3 cols to the left,
i.e. in cols A to C from row2 down, e.g.:

02-Mar-05 12-Apr-05 21-May-05
11-Jan-05 01-Feb-05 31-Mar-05
etc

Put in the formula bar for D2
and array-enter (i.e. press CTRL+SHIFT+ENTER):
=IF($A2:$C2="","",--($A2:$C2<=D$1))

Copy D2 across to H2, fill down as required
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----