This will work for one week:

=TODAY()+CHOOSE(WEEKDAY(P9,1),1,2,3,4,5,6,7)

And for bi-weekly, one of these two formulas:

=IF(ISODD(INT((TODAY()-P9)/7)),
TODAY()+CHOOSE(WEEKDAY(P9,1),8,9,10,11,12,13,14),
TODAY()+CHOOSE(WEEKDAY(P9,1),1,2,3,4,5,6,7))

or

=IF(ISODD(INT((TODAY()-P9)/7)),
,TODAY()+CHOOSE(WEEKDAY(P9,1),1,2,3,4,5,6,7),
TODAY()+CHOOSE(WEEKDAY(P9,1),8,9,10,11,12,13,14))


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60064