Formula to show correct month?

  • Thread starter Thread starter MitchellWMA
  • Start date Start date
M

MitchellWMA

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
 
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)?
 
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?
 
Try using exactly the same formula in both columns, but format the
second one as "mmm"
 
Try using exactly the same formula in both columns, but format the
second one as "mmm"
Click to expand...

Sorry folks! I was in the middle of writing up this post when they
came to advise me the contract wasn't being extended and that they
were also letting everyone all go early, so I was a bit rushed to
finish everything up. I do apologize if this was not clear enough at
the time. I didn't want to waste the message I'd started so I ended
up posting without proofreading as much as I like due to the time
constraints. Didn't realize it was so lacking in info. I'm at home
now and can look at this more calmly.

The code for the days in column J as shown below, work perfectly
well. It's the month, formatted as mmm in column I that I don't have
right.

I J
(Mon/Lun) <=text
Dec 29

(Tues/Mar) <=text
Dec 30

(Wed/Mer) <=text
Dec 31

(Thurs/Jeu) <=text
Dec 01

(Fri/Ven) <=text
Dec 02

(Sat/Sam) <=text
Dec 03

(Sun/Dim) <=text
Dec 04

I have column I with formula "=TODAY()" which is dumb, of course.
Stupid not to have seen that before but up till now, month was
correct ::g::.
Formatting for the month is in mmm format. What's needed is to have
right month of "Jan" show up for the 1st to the 4th and to show
correctly for any month.

thx Hope this is clearer now.
 
Try using exactly the same formula in both columns, but format the
second one as "mmm"
Click to expand...

I did try that earlier and it didn't work. But I was re-reading your
post just now and it popped into my head to try something else.

I J
(Mon/Lun) <=text
Dec 29

(Tues/Mar) <=text
Dec 30

(Wed/Mer) <=text
Dec 31

(Thurs/Jeu) <=text
Jan 01

J10 for Tues shows "30" with formula "=J7+1". In I11 to the left of
it and under the "Tues/Mar", I put in "=$J10" and then copied that
formula into the cells in column I below and that _seems_ to have
worked. The initial formula didn't but using instead a dependency on
the first cell in J seems to. I'll just have to see over time if the
month is displayed correctly each week.

Thx
 
Back
Top