View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ajay ajay is offline
external usenet poster
 
Posts: 43
Default Week Day formula usage????

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