View Single Post
  #2   Report Post  
Tsjah
 
Posts: n/a
Default

Never mind, I've figured it out myself:

=IF(VLOOKUP(DATE(YEAR(NOW())-5;MONTH(NOW());DAY(NOW()));$A:$A;1)=DATE(YEAR(NOW( ))-5;MONTH(NOW());DAY(NOW()));INDIRECT(ADDRESS(MATCH( DATE(YEAR(NOW())-5;MONTH(NOW());DAY(NOW()));$A:$A;1);1));INDIRECT(A DDRESS(MATCH(DATE(YEAR(NOW())-5;MONTH(NOW());DAY(NOW()));$A:$A;1)+1;1)))

Thanks anyway,

Mike