Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |