I have a spreadsheet that I D/L daily where column C2 is formatted as Date
like 1/6/2004.
I originally wanted the week number but this fails?
So, I tried to get the Week or Month in various ways with the following
results:
WEEKNUM(C2) = 1/2/1900 ???
LEFT(C2,1) = 3 ???

Can anyone tell me what I am doing wrong?

Thanks!

Hi
for the weeknum formula format the target cell as 'Number' (Fornat - Cells
menu)

--
Regards
Frank Kabel
Frankfurt, Germany

RustyR wrote:
I have a spreadsheet that I D/L daily where column C2 is formatted as
Date like 1/6/2004.
I originally wanted the week number but this fails?
So, I tried to get the Week or Month in various ways with the
following results:
WEEKNUM(C2) = 1/2/1900 ???
LEFT(C2,1) = 3 ???

Can anyone tell me what I am doing wrong?

Thanks!

Remeber that these are really numbers (well I hope they
are) You can either covert these to a month by entering a
formula:

=TEXT(A1,"MMM") - short month name
=TEXT(A1,"MMMM") - full month name


Or you could use a custome format ad just type MMM or MMMM
into the input field in the format cells, number, custom.

Rusty,
Assuming that you have a date in c1
entering "=Month(C1) will give you the number of month. A date is not a
string and would have to be converted to a string before attempting to use
string functions, like you were attempting to do.

"RustyR" wrote:

I have a spreadsheet that I D/L daily where column C2 is formatted as Date
like 1/6/2004.
I originally wanted the week number but this fails?
So, I tried to get the Week or Month in various ways with the following
results:
WEEKNUM(C2) = 1/2/1900 ???
LEFT(C2,1) = 3 ???

Can anyone tell me what I am doing wrong?

Thanks!