=42048+(MATCH(13,DAY(42048+ROW(OFFSET($A$1,(NOW()-42048)/7,1,200,1))*7),0)+ROUNDDOWN((NOW()-42048)/7,0))*7
Another CSE function.
a little longer at 106 chars (+2 for {} ?)
but should give :
12/3/2015 = 13/3/2015
13/3/2015 = 13/11/2015
EDIT:
replace rounddown by INT brings it to 98!
=42048+(MATCH(13,DAY(42048+ROW(OFFSET($A$1,(NOW()-42048)/7,1,200,1))*7),0)+INT((NOW()-42048)/7))*7
Last edited by a moderator: Feb 16, 2015