Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find out from a date if it is a red letter day or not
Hi Max,
Holiday differs from Nation to Nation. If you want to know if a specific date is a Sunday you can use the following: Type a date in A1 and put =WEEKDAY(A1,1) in B1 and apply a conditional formating in A1 under conditional formating select formula is and in formula type $B$1=1 and select red as the format see help for WEEKDAY TO get a more help on Day Number Abdul Salam -----Original Message----- I need to know how I can get out of a date like "24.12.03" if it is a red letter day (holiday) or not. It would be very great when somebody is able to tell me how i can get this!! thx max . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the first letter in a cell | Excel Discussion (Misc queries) | |||
Find cell containing a letter | Excel Discussion (Misc queries) | |||
Find Capital Letter | Excel Worksheet Functions | |||
find column letter | Excel Discussion (Misc queries) | |||
How do I find out what time I wrote A letter? | Excel Discussion (Misc queries) |