Converting date to day number

[Chris]

I want to have two columns:
the first with date;
the second with the corresponding day number.

How do I do that?

I don't care what the day numbers are - as long as they are sequential.
--
Chris

[Ian]

Excel already stores dates as sequential numbers. Assuming your date is in
A1, in B1 type =A1 and format as General.

--
Ian
--
"Chris" <nospam@[127.0.0.1]> wrote in message
news:k38EevWZrclDFw4v@[127.0.0.1]...
>I want to have two columns:
> the first with date;
> the second with the corresponding day number.
>
> How do I do that?
>
> I don't care what the day numbers are - as long as they are sequential.
> --
> Chris.

[Peo Sjoblom]

That would be days since Jan 0 1900, I am not sure the OP wanted that

=DAY(A1)

will return the day of the month

=A1-DATE(2005,1,1)+1

will return the day of the year

format as general

--

Regards,

Peo Sjoblom

"Ian" <me@me.com> wrote in message
news:L4klf.21935$0o2.10073@newsfe3-gui.ntli.net...
> Excel already stores dates as sequential numbers. Assuming your date is in
> A1, in B1 type =A1 and format as General.
>
> --
> Ian
> --
> "Chris" <nospam@[127.0.0.1]> wrote in message
> news:k38EevWZrclDFw4v@[127.0.0.1]...
> >I want to have two columns:
> > the first with date;
> > the second with the corresponding day number.
> >
> > How do I do that?
> >
> > I don't care what the day numbers are - as long as they are sequential.
> > --
> > Chris.
>
>

[Niek Otten]

=Weekday(A1) will return the day of the week, which was my interpretation of
the question!

--
Kind regards,

Niek Otten

"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:uOLVi6o%23FHA.3392@TK2MSFTNGP14.phx.gbl...
> That would be days since Jan 0 1900, I am not sure the OP wanted that
>
> =DAY(A1)
>
> will return the day of the month
>
> =A1-DATE(2005,1,1)+1
>
> will return the day of the year
>
> format as general
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "Ian" <me@me.com> wrote in message
> news:L4klf.21935$0o2.10073@newsfe3-gui.ntli.net...
>> Excel already stores dates as sequential numbers. Assuming your date is
>> in
>> A1, in B1 type =A1 and format as General.
>>
>> --
>> Ian
>> --
>> "Chris" <nospam@[127.0.0.1]> wrote in message
>> news:k38EevWZrclDFw4v@[127.0.0.1]...
>> >I want to have two columns:
>> > the first with date;
>> > the second with the corresponding day number.
>> >
>> > How do I do that?
>> >
>> > I don't care what the day numbers are - as long as they are sequential.
>> > --
>> > Chris.
>>
>>
>
>

[Chris]

In article <L4klf.21935$0o2.10073@newsfe3-gui.ntli.net>, Ian <me@me.com>
writes
>"Chris" <nospam@[127.0.0.1]> wrote in message
>news:k38EevWZrclDFw4v@[127.0.0.1]...

>>I want to have two columns:
>> the first with date;
>> the second with the corresponding day number.
>> How do I do that?
>> I don't care what the day numbers are - as long as they are sequential.

>Excel already stores dates as sequential numbers. Assuming your date is
>in A1, in B1 type =A1 and format as General.

Thanks, Ian - that's exactly what I wanted.
Much obliged.
--
Chris