Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--

If you simply want to display date as day of week, CUSTOM format cell as
"dddd" (no quotes) (and 17th March 2007 is Saturday on my calendar))

"Ajay" wrote:

Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--

Hi Toppers,
The below does not work, i want the cell / formula to tell me if its Sunday,
Saturday and if the date falls on a Weekday, i should say as "Weekday", Pls
let me know if its possible using Weeday formula??.
--Ajay--

"Toppers" wrote:

If you simply want to display date as day of week, CUSTOM format cell as
"dddd" (no quotes) (and 17th March 2007 is Saturday on my calendar))

"Ajay" wrote:

Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--

The WEEKDAY( ) function returns a number relating to the day of the
week - you could then turn this number into the name of the day using
something like CHOOSE, or LOOKUP.

However, an easier way is to put this formula in B1:

=A1

and format B1 using Custom to "dddd". Alternatively, use a custom
format on cell A1 as "dddd, mmm dd yyyy" to save using another column.

Hope this helps.

Pete

On Mar 16, 9:19 pm, Ajay wrote:
Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--

Saturday??????

If A1 contains the date (not 17th), you could just format the cell:

Format|Cells|number tab|Custom category
dddd

If you wanted to use another cell to return Saturday, you could use:
=a1
and format it as dddd
or
=text(a1,"dddd")



Ajay wrote:

Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--

--

Dave Peterson

Try this then:

=IF(WEEKDAY(A1,2)<6,"Weekday",IF(WEEKDAY(A1,2)=6," Saturday","Sunday"))

Hope this helps.

Pete

On Mar 16, 9:34 pm, Ajay wrote:
Hi Toppers,
The below does not work, i want the cell / formula to tell me if its Sunday,
Saturday and if the date falls on a Weekday, i should say as "Weekday", Pls
let me know if its possible using Weeday formula??.
--Ajay--



"Toppers" wrote:
If you simply want to display date as day of week, CUSTOM format cell as
"dddd" (no quotes) (and 17th March 2007 is Saturday on my calendar))

"Ajay" wrote:

Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--- Hide quoted text -

- Show quoted text -

=WEEKDAY(A1,1)

Look at HELP on WEEKDAY function

The above will return Saturday for 17/03/07 if cell is formatted as "dddd"

"Ajay" wrote:

Hi Toppers,
The below does not work, i want the cell / formula to tell me if its Sunday,
Saturday and if the date falls on a Weekday, i should say as "Weekday", Pls
let me know if its possible using Weeday formula??.
--Ajay--

"Toppers" wrote:

If you simply want to display date as day of week, CUSTOM format cell as
"dddd" (no quotes) (and 17th March 2007 is Saturday on my calendar))

"Ajay" wrote:

Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--

The formula is:

A B C
1 03/14/2007 =TEXT(A1,"dddd")
=IF(AND(weekday(A2)<1,weekday(A2)<7),"WEEKDAY"," ")
2
3
4

Thanks and Have a great weekend,
--
Farhad Hodjat


"Ajay" wrote:

Hi Toppers,
The below does not work, i want the cell / formula to tell me if its Sunday,
Saturday and if the date falls on a Weekday, i should say as "Weekday", Pls
let me know if its possible using Weeday formula??.
--Ajay--

"Toppers" wrote:

If you simply want to display date as day of week, CUSTOM format cell as
"dddd" (no quotes) (and 17th March 2007 is Saturday on my calendar))

"Ajay" wrote:

Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--

Hi Pete,
Thanks, It worked..,
I have another query too..,its with the heading "Time Calculation -
Critical", Can you please check and assist.,
Happy Weekend..,
Regards,
--Ajay--

"Pete_UK" wrote:

Try this then:

=IF(WEEKDAY(A1,2)<6,"Weekday",IF(WEEKDAY(A1,2)=6," Saturday","Sunday"))

Hope this helps.

Pete

On Mar 16, 9:34 pm, Ajay wrote:
Hi Toppers,
The below does not work, i want the cell / formula to tell me if its Sunday,
Saturday and if the date falls on a Weekday, i should say as "Weekday", Pls
let me know if its possible using Weeday formula??.
--Ajay--



"Toppers" wrote:
If you simply want to display date as day of week, CUSTOM format cell as
"dddd" (no quotes) (and 17th March 2007 is Saturday on my calendar))

"Ajay" wrote:

Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--- Hide quoted text -

- Show quoted text -

Thanks for the feedback - glad to help. I see you've already had lots
of suggestions in your other thread, and it's getting late here.

Pete

On Mar 16, 10:13 pm, Ajay wrote:
Hi Pete,
Thanks, It worked..,
I have another query too..,its with the heading "Time Calculation -
Critical", Can you please check and assist.,
Happy Weekend..,
Regards,
--Ajay--



"Pete_UK" wrote:
Try this then:

=IF(WEEKDAY(A1,2)<6,"Weekday",IF(WEEKDAY(A1,2)=6," Saturday","Sunday"))

Hope this helps.

Pete

On Mar 16, 9:34 pm, Ajay wrote:
Hi Toppers,
The below does not work, i want the cell / formula to tell me if its Sunday,
Saturday and if the date falls on a Weekday, i should say as "Weekday", Pls
let me know if its possible using Weeday formula??.
--Ajay--

"Toppers" wrote:
If you simply want to display date as day of week, CUSTOM format cell as
"dddd" (no quotes) (and 17th March 2007 is Saturday on my calendar))

"Ajay" wrote:

Hi,
Can someone tell me how to use WEEKDAY function??.

Ex:
Imagine A1 has March 17th 2007

The formula should finally say that A1 is "Sunday"

Pls let me know.
--Ajay--- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -