software

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: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=531313I don't see how that formula advances a week, it just seems to calculate a
number of days between today and some defined date.

If you want Noon, just add .5 to the result, as dates are stored as days
since 1/1/1900, and time is a fraction of one day.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;lsmftquot; gt; wrote in
message ...
gt;
gt; I am currently using the formula below to automatically advance a week
gt; on each Sunday. My question is: is it possible to have this advance
gt; take place on Sunday at noon instead of Saturday night at midnight?
gt; =ROUNDUP(((TODAY()-38724)/7),0)
gt; Thank you for your help.
gt;
gt;
gt; --
gt; lsmft
gt; ------------------------------------------------------------------------
gt; lsmft's Profile:
www.excelforum.com/member.php...oamp;userid=30678
gt; View this thread: www.excelforum.com/showthread...hreadid=531313
gt;
=ROUNDUP(((NOW()-38725.5)/7),0)

HTH
--
AP

quot;lsmftquot; gt; a écrit dans le
message de ...
gt;
gt; I am currently using the formula below to automatically advance a week
gt; on each Sunday. My question is: is it possible to have this advance
gt; take place on Sunday at noon instead of Saturday night at midnight?
gt; =ROUNDUP(((TODAY()-38724)/7),0)
gt; Thank you for your help.
gt;
gt;
gt; --
gt; lsmft
gt; ------------------------------------------------------------------------
gt; lsmft's Profile:
www.excelforum.com/member.php...oamp;userid=30678
gt; View this thread: www.excelforum.com/showthread...hreadid=531313
gt;