If formula with Date Range

[Guest]

Hello guys, this is what I need to do, if the date range of cell A1 is
anywhere between 10/30/04 thru 11/05/04, then I need it to say week nbr 40.
Is this possible with a if formula without having to type up 10/30/04, then
10/31/04 all the way till 11/05?

 

[JulieD]

Hi Javy

try

=IF(AND(A1>DATEVALUE("10/30/04"),A1<DATEVALUE("11/05/04")),"week nbr 40","")

Cheers
JulieD

 

[Guest]

Worked like a charm, thanks a million.

Hi Javy

try

=IF(AND(A1>DATEVALUE("10/30/04"),A1<DATEVALUE("11/05/04")),"week nbr 40","")

Cheers
JulieD

 

[JulieD]

you're welcome

Worked like a charm, thanks a million.

 

[Myrna Larson]

If you need to have Excel determine the week number rather than doing it
manually, look at the WEEKNUM function in Help. In particular, do that if the
function returns the #NAME! error.