Advancing Timing
 

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

Advancing Timing
 

I 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)

"lsmft" wrote in
message ...

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

Advancing Timing
 

=ROUNDUP(((NOW()-38725.5)/7),0)

HTH
--
AP

"lsmft" a écrit dans le
message de ...

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