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
.
|