Hi,

The Names are in Col A, Dates are in Col B, then few blank rows, then
the 3 cells in which i want the formulas (say in columns G, H I)...

Hope this helps!




Pete_UK wrote:
It would be a bit easier if you had specified the actual column that
the joining dates were in, so I have assumed the dates occupy D2 to
D100 - adjust as necessary. Try these array formulae*:

=SUM(IF(TODAY()-D2:D100<90,1,0))

=SUM(IF((TODAY()-D2:D100=90)*(TODAY()-D2:D100<=180),1,0))

=SUM(IF(TODAY()-D2:D100180,1,0))

*As these are array formulae, once you have typed them in (or if you
subsequently edit them) you must use CTRL-SHIFT-ENTER rather than just
ENTER. If you do this correctly, Excel will wrap curly braces { }
around the formula - you must not type these yourself.

This should give you what you want.

Hope this helps.

Pete