Advancing Timing

L

lsmft

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

Bob Phillips

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