 |
 | 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 / Worksheet Functions / June 2007Every 1st, 3rd, 5th Tuesday
Hi, I have a start date of 2 Jan 07 in A1 - the 1st Tuesday of the month. How can I get the cells below populated with the dates of the 1st, 3rd and 5th Tuesdays of every month? Tks, Ricky >Hi, > [quoted text clipped - 4 lines] > >Tks, Ricky A2: =A1+7 Fill down as far as required. --ron >>I have a start date of 2 Jan 07 in A1 - the 1st Tuesday of the month. >> [quoted text clipped - 4 lines] > > A2: =A1+7 +14 ??? Rick On Mon, 11 Jun 2007 22:10:24 -0400, "Rick Rothstein \(MVP - VB\)" <rickNOSPAMnews@NOSPAMcomcast.net> wrote: >>>I have a start date of 2 Jan 07 in A1 - the 1st Tuesday of the month. >>> [quoted text clipped - 8 lines] > >Rick Duh, of course <hand slapping forehead> --ron On Mon, 11 Jun 2007 22:10:24 -0400, "Rick Rothstein \(MVP - VB\)" <rickNOSPAMnews@NOSPAMcomcast.net> wrote: >>>I have a start date of 2 Jan 07 in A1 - the 1st Tuesday of the month. >>> [quoted text clipped - 8 lines] > >Rick Actually, no, that would be wrong. As was my initial. --ron >Hi, > [quoted text clipped - 4 lines] > >Tks, Ricky Sorry, my first answer was incorrect. Try this: =A1+7+7*(MONTH(A1+7)=MONTH(A1)) --ron Geez, I feel very embarrassed to have posted that question! Thanks Ron/Rick for your responses. Ricky (smacking his forehead after realizing the solution) >Hi, > [quoted text clipped - 4 lines] > >Tks, Ricky >Geez, I feel very embarrassed to have posted that question! > [quoted text clipped - 11 lines] >> >>Tks, Ricky Best to check my last answer. --ron > Geez, I feel very embarrassed to have posted that question! Don't be... initially, we were both wrong. However, Ron came up with the correct formula afterwards.... check out his other responses. Rick Thanks for that formula Ron. I just camne home form work ready to post the question again with "that won't work". But you guys already realised that! Cheers, Ricky |
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.