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 -