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