Current Monday and future Sunday. MitchellWMA <mitchellwma1[ at ]yahoo.com> 12/15/2008 3:29:54 PM I google the archives and came up with this for the Monday of the current week, i.e., I start the work week on Mondays and that's how my time sheets operate. So today being the first day of the work week which ends the following Sunday, here is what I found for Monday of the current week: =2-WEEKDAY(TODAY())+TODAY() So today the time sheet shows Dec.15 for today, Monday. How can I get next Sunday's date formulaically, which would be Dec.21? Thanks! :)

RE: Current Monday and future Sunday. Gary''s Student 12/15/2008 3:41:01 PM How about: =8-WEEKDAY(TODAY())+TODAY() -- Gary''s Student - gsnu2007k "MitchellWMA" wrote: [Quoted Text] > I google the archives and came up with this for the Monday of the > current week, i.e., I start the work week on Mondays and that's how my > time sheets operate. So today being the first day of the work week > which ends the following Sunday, here is what I found for Monday of > the current week: > > =2-WEEKDAY(TODAY())+TODAY() > > So today the time sheet shows Dec.15 for today, Monday. > > How can I get next Sunday's date formulaically, which would be Dec.21? > > Thanks! :) >

Re: Current Monday and future Sunday. Gord Dibben <gorddibbATshawDOTca> 12/15/2008 3:44:05 PM =cellref + 6 Where cellref is the cell with your WEEKDAY formula. Gord Dibben MS Excel MVP On Mon, 15 Dec 2008 07:29:54 -0800 (PST), MitchellWMA <mitchellwma1[ at ]yahoo.com> wrote: [Quoted Text] >I google the archives and came up with this for the Monday of the >current week, i.e., I start the work week on Mondays and that's how my >time sheets operate. So today being the first day of the work week >which ends the following Sunday, here is what I found for Monday of >the current week: > >=2-WEEKDAY(TODAY())+TODAY() > >So today the time sheet shows Dec.15 for today, Monday. > >How can I get next Sunday's date formulaically, which would be Dec.21? > >Thanks! :)

Re: Current Monday and future Sunday. MitchellWMA <mitchellwma1[ at ]yahoo.com> 12/15/2008 4:34:38 PM On Dec 15, 10:41 am, Gary''s Student <GarysStud...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > How about: > =8-WEEKDAY(TODAY())+TODAY() > -- > Gary''s Student - gsnu2007k So that's how it works. I'm guessing that 2 is for Monday since it actually is the 2nd day of the week, and 8 makes the following Sunday, which would otherwise be #1 of the following week, the "last" day of the week as far as my time sheet goes. They sent us the time sheet in Excel so much easier to just put the formulas in and print out anytime during the weekend before Friday afternoon. I _was_ currently using the formula =J26 for Sunday as Sunday is shown on the sheet, but it's much better to have a separate formula in this case. Too many other parts of the formula are based on adding "1" to the cell above it for the right date for each day of the week. Thanks. :)

Re: Current Monday and future Sunday. MitchellWMA <mitchellwma1[ at ]yahoo.com> 12/30/2008 3:39:26 PM Forgot to update this thread. Thought would be a good idea to list code for all days of the week: Sunday of this current week: =1-WEEKDAY(TODAY())+TODAY() Monday of this current week: =2-WEEKDAY(TODAY())+TODAY() Tuesday of this current week: =3-WEEKDAY(TODAY())+TODAY() Wednesday of this current week: =4-WEEKDAY(TODAY())+TODAY() Thursday of this current week: =5-WEEKDAY(TODAY())+TODAY() Friday of this current week: =6-WEEKDAY(TODAY())+TODAY() Saturday of this current week: =7-WEEKDAY(TODAY())+TODAY() SUNDAY of following week, when Monday & not Sunday is used as day #1 of week: =8-WEEKDAY(TODAY())+TODAY() Thx. <g>

Re: Current Monday and future Sunday. "Shane Devenshire" <shanedevenshire[ at ]sbcglobal.net> 12/30/2008 4:53:58 PM Please keep your threads together, stuff like this if very difficult to follow and a waste of our time. Thx <s> "MitchellWMA" <mitchellwma1[ at ]yahoo.com> wrote in message news:a5188c43-ca29-4c8a-8143-a0c2e51ee3d9[ at ]q18g2000vbn.googlegroups.com... [Quoted Text] > Forgot to update this thread. Thought would be a good idea to list > code for all days of the week: > > Sunday of this current week: =1-WEEKDAY(TODAY())+TODAY() > Monday of this current week: =2-WEEKDAY(TODAY())+TODAY() > Tuesday of this current week: =3-WEEKDAY(TODAY())+TODAY() > Wednesday of this current week: =4-WEEKDAY(TODAY())+TODAY() > Thursday of this current week: =5-WEEKDAY(TODAY())+TODAY() > Friday of this current week: =6-WEEKDAY(TODAY())+TODAY() > Saturday of this current week: =7-WEEKDAY(TODAY())+TODAY() > SUNDAY of following week, when > Monday & not Sunday is used > as day #1 of week: =8-WEEKDAY(TODAY())+TODAY() > > Thx. <g>