| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
Dear All,
I have time sheet, which have Date and day columns in day column I gave the ref. to A1 and change the format to "DDD", It shows the day e.g. Mon or Tue. Now I want to apply formula that if b1="Sat" or "Sun" then return Off in c1 otherwise Morning in C1, but I am getting Morning in all cells. Kindly advise what I have to mention in formula instead of Sat. formula in C1 is "=if(b1="Sat"."Off",if(b1="Sun","Off","Morning ")) I tried full day but same result. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Threaded Mode
