Formula to show correct month? MitchellWMA <mitchellwma1[ at ]yahoo.com> 12/31/2008 3:12:38 PM Good morning. Cells formatted with '=2-WEEKDAY(TODAY())+TODAY()' are showing the correct day of the month since I used a sum +1 formula for subsequent days. That seems to do the job. The cells in the left column of the day of the month that show just the month using '=TODAY()' are showing "Dec" for yesterday and today, which is correct, but also show "Dec" for tomorrow and Friday, which is not since it should be January. I'm afraid that I don't know how to get the right month formula. Anything I've tried doesn't work. I stupidly tried things like '=I8+1' for subsequent cells but that displays 'Jan' for today which is not good since we're still "Dec". What can be done to the =TODAY() formula that gets it to display correctly please? Or is there something better? thx

Re: Formula to show correct month? JE McGimpsey <jemcgimpsey[ at ]mvps.org> 12/31/2008 4:07:53 PM Not sure what the problem is - the formula gives you the Monday at the start of the current date's week. Tomorrow (1/1/2009) and Friday's week starts in December too.... What would you expect to see on Apr 1 (a Wednesday)? In article <871fdf67-3ab7-46f4-aeeb-1d1b2b56fed5[ at ]a29g2000pra.googlegroups.com>, MitchellWMA <mitchellwma1[ at ]yahoo.com> wrote: [Quoted Text] > Good morning. > > Cells formatted with '=2-WEEKDAY(TODAY())+TODAY()' are showing the > correct day of the month since I used a sum +1 formula for subsequent > days. That seems to do the job. > > The cells in the left column of the day of the month that show just > the month using '=TODAY()' are showing "Dec" for yesterday and today, > which is correct, but also show "Dec" for tomorrow and Friday, which > is not since it should be January. I'm afraid that I don't know how > to get the right month formula. Anything I've tried doesn't work. I > stupidly tried things like '=I8+1' for subsequent cells but that > displays 'Jan' for today which is not good since we're still "Dec". > > What can be done to the =TODAY() formula that gets it to display > correctly please? Or is there something better? thx

Re: Formula to show correct month? njem <njem[ at ]q.com> 12/31/2008 4:10:56 PM Not quite clear on this. You're doing a calendar relative to today? On 12/31 the formula Month(today()) gives 12 and Month(today()+1) gives 1. What result are you looking for? On Dec 31, 8:12 am, MitchellWMA <mitchellw...[ at ]yahoo.com> wrote: [Quoted Text] > Good morning. > > Cells formatted with '=2-WEEKDAY(TODAY())+TODAY()' are showing the > correct day of the month since I used a sum +1 formula for subsequent > days.  That seems to do the job. > > The cells in the left column of the day of the month that show just > the month using '=TODAY()' are showing "Dec" for yesterday and today, > which is correct, but also show "Dec" for tomorrow and Friday, which > is not since it should be January.  I'm afraid that I don't know how > to get the right month formula.  Anything I've tried doesn't work.  I > stupidly tried things like '=I8+1' for subsequent cells but that > displays 'Jan' for today which is not good since we're still "Dec". > > What can be done to the =TODAY() formula that gets it to display > correctly please? Or is there something better?  thx

Re: Formula to show correct month? barry houdini <barry.houdini[ at ]virgin.net> 12/31/2008 4:17:59 PM Try using exactly the same formula in both columns, but format the second one as "mmm"