 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Determine next Saturday in calendar based on date in a cell
I need to determine the following Saturday based on a given date in a cell. For example, in one cell I have a date of 10/8/2006 - I need a function to return the date of 10/14/2006. Please don't post the same question to different workgroups in separate posts. Your question has been answered in another newsgroup.  SignatureKind regards, Niek Otten Microsoft MVP - Excel |I need to determine the following Saturday based on a given date in a cell. | For example, in one cell I have a date of 10/8/2006 - I need a function to | return the date of 10/14/2006. It wasn't intentional - I only posted once so not sure how it got here. I apologize profusely. > Please don't post the same question to different workgroups in separate posts. > Your question has been answered in another newsgroup. > > |I need to determine the following Saturday based on a given date in a cell. > | For example, in one cell I have a date of 10/8/2006 - I need a function to > | return the date of 10/14/2006. No problem, Ann. We just keep saying it, nothing personal. SignatureKind regards, Niek Otten Microsoft MVP - Excel | It wasn't intentional - I only posted once so not sure how it got here. I | apologize profusely. [quoted text clipped - 5 lines] | > | For example, in one cell I have a date of 10/8/2006 - I need a function to | > | return the date of 10/14/2006. Ann, Niek answered your question in worksheet functions, no need to post to more than one group, if this will not work post back to the same post as you started, easier to keep track of that way From worksheet functions newsgroup =A1+IF(WEEKDAY(A1)=7,14,7)-WEEKDAY(A1) SignatureKind regards, Niek Otten Microsoft MVP - Excel -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 >I need to determine the following Saturday based on a given date in a cell. > For example, in one cell I have a date of 10/8/2006 - I need a function to > return the date of 10/14/2006. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.