How do you change the date to a Number, example Jan 1, 2005 is the 1st day of
the year and so on...

Hi
do you mean something like
=A1-DATE(2004,12,31)
and format as number there A1 stores your 2005 date

--
Regards
Frank Kabel
Frankfurt, Germany

help me wrote:
How do you change the date to a Number, example Jan 1, 2005 is the
1st day of the year and so on...

Not exactly I mean Jan 1st is the first day of the year, so I want the cell
to have the number one in it. Jan 20, feb 1st is the 32nd day of the year, so
I would like the sell to have the number 32 in it.

"Frank Kabel" wrote:

Hi
do you mean something like
=A1-DATE(2004,12,31)
and format as number there A1 stores your 2005 date

--
Regards
Frank Kabel
Frankfurt, Germany

help me wrote:
How do you change the date to a Number, example Jan 1, 2005 is the
1st day of the year and so on...

Even if you have a text format or an apostrophe ' before January 1, 2005,
=day(a1) will yield 1

--
Don Guillett
SalesAid Software

"help me" <help wrote in message
...
How do you change the date to a Number, example Jan 1, 2005 is the 1st day
of
the year and so on...

is this what you want?
=TODAY()-DATE(YEAR(TODAY()),1,1)

--
Don Guillett
SalesAid Software

"help me" wrote in message
...
Not exactly I mean Jan 1st is the first day of the year, so I want the
cell
to have the number one in it. Jan 20, feb 1st is the 32nd day of the year,
so
I would like the sell to have the number 32 in it.

"Frank Kabel" wrote:

Hi
do you mean something like
=A1-DATE(2004,12,31)
and format as number there A1 stores your 2005 date

--
Regards
Frank Kabel
Frankfurt, Germany

help me wrote:
How do you change the date to a Number, example Jan 1, 2005 is the
1st day of the year and so on...

I tried to put 'january 1, 2005 into cell A1 and then entered =day(a1) into a
different cell but someting is wrong. the cell says #value now. where did I
go wrong..

"Don Guillett" wrote:

Even if you have a text format or an apostrophe ' before January 1, 2005,
=day(a1) will yield 1

--
Don Guillett
SalesAid Software

"help me" <help wrote in message
...
How do you change the date to a Number, example Jan 1, 2005 is the 1st day
of
the year and so on...

Thanks, now how can I change the date

"Don Guillett" wrote:

is this what you want?
=TODAY()-DATE(YEAR(TODAY()),1,1)

--
Don Guillett
SalesAid Software

"help me" wrote in message
...
Not exactly I mean Jan 1st is the first day of the year, so I want the
cell
to have the number one in it. Jan 20, feb 1st is the 32nd day of the year,
so
I would like the sell to have the number 32 in it.

"Frank Kabel" wrote:

Hi
do you mean something like
=A1-DATE(2004,12,31)
and format as number there A1 stores your 2005 date

--
Regards
Frank Kabel
Frankfurt, Germany

help me wrote:
How do you change the date to a Number, example Jan 1, 2005 is the
1st day of the year and so on...

I don't know about Frank or the others, but exactly what do you want?
Another cell with a date in it or the day of the current date???
Pls be VERY clear.

--
Don Guillett
SalesAid Software

"help me" wrote in message
...
Thanks, now how can I change the date

"Don Guillett" wrote:

is this what you want?
=TODAY()-DATE(YEAR(TODAY()),1,1)

--
Don Guillett
SalesAid Software

"help me" wrote in message
...
Not exactly I mean Jan 1st is the first day of the year, so I want the
cell
to have the number one in it. Jan 20, feb 1st is the 32nd day of the
year,
so
I would like the sell to have the number 32 in it.

"Frank Kabel" wrote:

Hi
do you mean something like
=A1-DATE(2004,12,31)
and format as number there A1 stores your 2005 date

--
Regards
Frank Kabel
Frankfurt, Germany

help me wrote:
How do you change the date to a Number, example Jan 1, 2005 is the
1st day of the year and so on...

Hi
but this should just do this:
In A1 enter your date
in B1 for example enter this formula (and format this cell as 'Number')

--
Regards
Frank Kabel
Frankfurt, Germany

help me wrote:
Not exactly I mean Jan 1st is the first day of the year, so I want
the cell to have the number one in it. Jan 20, feb 1st is the 32nd
day of the year, so I would like the sell to have the number 32 in it.

"Frank Kabel" wrote:

Hi
do you mean something like
=A1-DATE(2004,12,31)
and format as number there A1 stores your 2005 date

--
Regards
Frank Kabel
Frankfurt, Germany

help me wrote:
How do you change the date to a Number, example Jan 1, 2005 is the
1st day of the year and so on...