dragging an indirect formula

[DeanRobinson]

Hi all im wondering if there is another way of doing the below formula so that when i drag across the E16:E goes along ie next cell would be F16:F.


=COUNTIF(INDIRECT("E16:E"&(TODAY()-E1)+16),"V")

 

[T. Valko]

Hi all im wondering if there is another way of doing the below formula so that when i drag across the E16:E goes along ie next cell would be F16:F.


=COUNTIF(INDIRECT("E16:E"&(TODAY()-E1)+16),"V")

Just so I can get an idea of the size of the range...

What's in E1?

 

[shg]

Maybe

=COUNTIF(E16:INDEX(E:E, TODAY() - E1 + 16), "V")

 

[DeanRobinson]

You asking that question has just made me realise im doing it wrong. E1 is the employees start date. what im trying to do if find out how many vacations ("V") someone has had between there start date E1 and today() my indirect should be moving the first part of the range aswell as the second.