This will tell you how many weeks have passed from the Semester starting
date ($F$3) until 'today'...
=TRUNC((((Now()-$F$3)-DATE(YEAR((Now()-$F$3)),1,1))/7))+1+IF(WEEKDAY(DATE(YEAR((Now()-$F$3)),1,1))WEEKDAY((Now()-$F$3)),1,0)
--
kghexce
------------------------------------------------------------------------
kghexce's Profile:
http://www.excelforum.com/member.php...o&userid=29804
View this thread:
http://www.excelforum.com/showthread...hreadid=524026