Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kevinUK
-
Excel and =DAY( )
Many thanks, yes =weekday(a1) does work (with ddd format), but I was just interested to find out why =day(a1) did not give the correct answer. KevinUK- kevinUK
- Post #3
- Forum: Microsoft: Office
-
Excel and =DAY( )
Today is Monday 15 December 2003, so I put this date in say cell A1 and in cell B1 enter the function =DAY(A1). If B1 is formatted using the custom format d or dd I get 15 as expected, but if I format the cell using ddd or dddd I get Sun or Sunday and not Mon or Monday as I would expect. All the...- kevinUK
- Thread
- Replies: 8
- Forum: Microsoft: Office
