I am currently using the formula below to automatically advance a week
on each Sunday. My question is: is it possible to have this advance
take place on Sunday at noon instead of Saturday night at midnight?
=ROUNDUP(((TODAY()-38724)/7),0)
Thank you for your help.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=531313