How do you change the date to a Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Even if you have a text format or an apostrophe ' before January 1, 2005,
=day(a1) will yield 1
 
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..
 
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.
 
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')
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW CAN WE CALCULATE INTEREST ACCURED BETWEEN TWODATES 3
Excel Message box with days of month & date. 1
Excel Vba to change displayed year automatically. 14
Can i drop the year from dd/mm/yyyy for graph 2
Converting date to week number over several years 3
My date formats changed 3
Auto Cell Format Change from General to Custom Date 1
Average Forumula 4

Back
Top