Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Hi Jeff
Try putting in B10 =CHOOSE(WEEKDAY(A10),"Sunday","Monday","Tuesday"," Wednesday","Thursday","Friday","Saturday") However, you may find that it is a Tuesday, rather than a Monday - at least in the UK!!! -- Regards Roger Govier "Jeff" wrote in message ... Hello, I have in column "A" row "10" the date as follow: 15-Feb-05. It is possible to get in column "B" row "10" the day of the week as follow: Monday ? Regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count weekdays in a date range | Excel Worksheet Functions | |||
Recognizing weekends and changing to weekdays in Excel | Excel Discussion (Misc queries) | |||
Date exclude weekdays | New Users to Excel |