Want day of the week when I insert a date

HT · 10-12-2005, 01:05 PM

**cross post from microsoft.public.excel**..no answer as of yet

Excel 2003
WindowsXP

I am creating a spreadsheet and inserting many dates. I want to insert the
date and have the day of the week of that particular date appear. Otherwise
I would have to look up years worth of dates.

Is there a way to do this?

Thank you.

Ron de Bruin · 10-12-2005, 01:05 PM

Hi

Format the cells like this
dddd

--
Regards Ron de Bruin
http://www.rondebruin.nl

"HT" <dkajfd@dkafjd.com> wrote in message news:%23X7XSc0zFHA.3408@TK2MSFTNGP09.phx.gbl...
> **cross post from microsoft.public.excel**..no answer as of yet
>
> Excel 2003
> WindowsXP
>
> I am creating a spreadsheet and inserting many dates. I want to insert the
> date and have the day of the week of that particular date appear. Otherwise
> I would have to look up years worth of dates.
>
> Is there a way to do this?
>
> Thank you.
>
>
>

bigwheel · 10-12-2005, 07:05 PM

Hi, =TEXT(A1, "dddd") if your date is in A1

"HT" wrote:

> **cross post from microsoft.public.excel**..no answer as of yet
>
> Excel 2003
> WindowsXP
>
> I am creating a spreadsheet and inserting many dates. I want to insert the
> date and have the day of the week of that particular date appear. Otherwise
> I would have to look up years worth of dates.
>
> Is there a way to do this?
>
> Thank you.
>
>
>
>

HT · 10-12-2005, 07:05 PM

Thanks guys..another user said to use Format, Cell, Number, Date and click
on the second option that includes the day with the date.

"bigwheel" <bigwheel@discussions.microsoft.com> wrote in message
news:F03CE483-2157-4FAB-A84C-A3140BC4BAA7@microsoft.com...
> Hi, =TEXT(A1, "dddd") if your date is in A1
>
> "HT" wrote:
>
> > **cross post from microsoft.public.excel**..no answer as of yet
> >
> > Excel 2003
> > WindowsXP
> >
> > I am creating a spreadsheet and inserting many dates. I want to insert
the
> > date and have the day of the week of that particular date appear.
Otherwise
> > I would have to look up years worth of dates.
> >
> > Is there a way to do this?
> >
> > Thank you.
> >
> >
> >
> >

**Thiem** · 10-13-2005, 06:23 AM

12/05/06 =WEEKDAY(A2,1) =VLOOKUP(B2,$A$11:$B$17,2,FALSE)

13/10/05 =WEEKDAY(A4,1) =VLOOKUP(B4,$A$11:$B$17,2,FALSE)

12/05/04 =WEEKDAY(A6,1) =VLOOKUP(B6,$A$11:$B$17,2,FALSE)

2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
1 Sunday

First read the Weekday Fuction to understand, If you start your week on a Sunday, the ref to enter will be 1, meaning 1 will be first day of the week or Sunday. Then you just do a vlookup as list above

Cheers

A

HT · 10-13-2005, 11:05 AM

Theim,

I am not familiar with creating these functions..but I would like to be
...how would I?

Thank you.

"Thiem" <Thiem.1wu7uj_1129201556.6449@excelforum-nospam.com> wrote in
message news:Thiem.1wu7uj_1129201556.6449@excelforum-nospam.com...
>
> 12/05/06 =WEEKDAY(A2,1) =VLOOKUP(B2,$A$11:$B$17,2,FALSE)
>
> 13/10/05 =WEEKDAY(A4,1) =VLOOKUP(B4,$A$11:$B$17,2,FALSE)
>
> 12/05/04 =WEEKDAY(A6,1) =VLOOKUP(B6,$A$11:$B$17,2,FALSE)
>
>
>
>
> 2 Monday
> 3 Tuesday
> 4 Wednesday
> 5 Thursday
> 6 Friday
> 7 Saturday
> 1 Sunday
>
>
>
> First read the Weekday Fuction to understand, If you start your week on
> a Sunday, the ref to enter will be 1, meaning 1 will be first day of the
> week or Sunday. Then you just do a vlookup as list above
>
> Cheers
>
> A
>
>
> --
> Thiem
> ------------------------------------------------------------------------
> Thiem's Profile:
http://www.excelforum.com/member.php...o&userid=27474
> View this thread: http://www.excelforum.com/showthread...hreadid=475514
>