| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing date as day of week
Followed the help and used Day function to calculate the day of the week then
formatted as custom to ddd to show short day name. But sometimes it returns wrong day. e.g. 09/05/2009 (F68). Formulae G68 is =DAY(F68), returns Mon. Buts its actually Sat??? Any ideas Thanks Trevor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
| Date showing incorrect. 30:00 hrs showing 06:00 | Excel Discussion (Misc queries) | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
![Trevor Aiston[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
