H
help me
How do you change the date to a Number, example Jan 1, 2005 is the 1st day of
the year and so on...
the year and so on...
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
do you mean something like
=A1-DATE(2004,12,31)
and format as number there A1 stores your 2005 date
do you mean something like
=A1-DATE(2004,12,31)
and format as number there A1 stores your 2005 date
H
help me
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.
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.
D
Don Guillett
Even if you have a text format or an apostrophe ' before January 1, 2005,
=day(a1) will yield 1
=day(a1) will yield 1
D
Don Guillett
is this what you want?
=TODAY()-DATE(YEAR(TODAY()),1,1)
=TODAY()-DATE(YEAR(TODAY()),1,1)
H
help me
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..
different cell but someting is wrong. the cell says #value now. where did I
go wrong..
H
help me
Thanks, now how can I change the date
Don Guillett said:is this what you want?
=TODAY()-DATE(YEAR(TODAY()),1,1)
D
Don Guillett
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.
Another cell with a date in it or the day of the current date???
Pls be VERY clear.
F
Frank Kabel
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')
but this should just do this:
In A1 enter your date
in B1 for example enter this formula (and format this cell as 'Number')