I'm not sure what you're looking for but if A1 has a date then this formula
in another cell will tell you if it is a Friday:

=IF(WEEKDAY(A1)=6,"Friday","Not Friday")

--
Jim
" wrote in message
ups.com...
| Hi,
|
| Suppose I have a excel column that contains the dates:
|
| Column A ( DD/MM/YY)
|
| 09/02/07
| 10/02/07
| etc
|
| How do I select the column and read in each dates in each cell to
| check if the date: (DD) is a friday and that the date is 6th?
|
| Thanks.
|
| regards,
| Newbie
|