| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Timing a macro | Excel Discussion (Misc queries) | |||
| Excel 2003 has wrong timing using the worksheet_change macro | Excel Worksheet Functions | |||
| Advancing Down A List | Excel Worksheet Functions | |||
| Prevent Formulas from Advancing | Excel Discussion (Misc queries) | |||
| Timing problem with OnAction! | Charts and Charting in Excel | |||
Linear Mode
