Re: Converting date to day number

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxx> wrote in message
news:L4klf.21935$0o2.10073@xxxxxxxxxxxxxxxxxxxxxxx
> 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.
>
>


.

Relevant Pages