Week Day formula usage????

A

Ajay

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--
 
T

Toppers

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))
 
A

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--
 
P

Pete_UK

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
 
D

Dave Peterson

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")
 
P

Pete_UK

Try this then:

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

Hope this helps.

Pete
 
T

Toppers

=WEEKDAY(A1,1)

Look at HELP on WEEKDAY function

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

Farhad

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,
 
A

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--
 
P

Pete_UK

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
 
Top