=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add another
three IF to this string so that I can get the month sorted out in Week order?

Hi

Why not just the weeknum function?
=WEEKNUM(A1)

For this to work you need Analysis Toolpak. ToolsAddinsClick Analysis
Toolpak.

--
Regards

Roger Govier


"Michell Major" wrote in
message ...
=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add
another
three IF to this string so that I can get the month sorted out in Week
order?

=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

Try it as:
=IF(AND(A4=--"4/12/2006",A4<=--"9/12/2006"),49)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michell Major" wrote:
=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add another
three IF to this string so that I can get the month sorted out in Week order?

Have you looked the Weeknum function?

"Michell Major" wrote:

=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add another
three IF to this string so that I can get the month sorted out in Week order?

Hi Michell Major,

=INT((A4-DATE(YEAR(A4),1,1))/7+1)
returns '49' for "3/12/2006"=A4<="9/12/2006" - a span of 7 days/1 week.

I don't understand the bit about the month, though.

Cheers
PS: 31/12/2006 will be the 1st day in week 53.

--
macropod
[MVP - Microsoft Word]


"Michell Major" wrote in message
...
=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add
another
three IF to this string so that I can get the month sorted out in Week
order?

max thanks, but see Roger's answer too. Regards


"Max" wrote:

=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

Try it as:
=IF(AND(A4=--"4/12/2006",A4<=--"9/12/2006"),49)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michell Major" wrote:
=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add another
three IF to this string so that I can get the month sorted out in Week order?

Roger

Fantastic!

Dan

"Roger Govier" wrote:

Hi

Why not just the weeknum function?
=WEEKNUM(A1)

For this to work you need Analysis Toolpak. ToolsAddinsClick Analysis
Toolpak.

--
Regards

Roger Govier


"Michell Major" wrote in
message ...
=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add
another
three IF to this string so that I can get the month sorted out in Week
order?

Hi Michell Major,

One thing to be aware of if other people are likely to use this workbook on
other systems is that they'll need to have the Analysis Toolpak installed
too, otherwise the WEEKNUM function won't work for them and they'll get no
warnings about it, either.

Cheers

--
macropod
[MVP - Microsoft Word]


"Michell Major" wrote in message
...
Roger

Fantastic!

Dan

"Roger Govier" wrote:

Hi

Why not just the weeknum function?
=WEEKNUM(A1)

For this to work you need Analysis Toolpak. ToolsAddinsClick Analysis
Toolpak.

--
Regards

Roger Govier


"Michell Major" wrote in
message ...
=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add
another
three IF to this string so that I can get the month sorted out in Week
order?

No prob. Go with Roger's much more apt response. Me?, was just focusing on
getting your attempt to work "as-is" <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michell Major" wrote in message
...
max thanks, but see Roger's answer too. Regards