Testing a Date

Hi Guys,
i'm using Microsoft Excel 2003 and i have a small problem which i will try to explane: i have to test a cell (format ddd) which contain the name of the day: in few word in that cell A1 i calculated, with the formula [Date(year,month,day)] the "name" of the day (f.i. "mon","tue","thu",etc.,etc). Now, in another cell (B1, for istance) i should have the necessity to show the value of the cell A1 only if the value of the cell A1 is "sat" (saturday) or "sun" (sunday). Could be somebody so kind to help me in this matter ? Thanks ion advance

Hi,

this should work

=IF(OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1),A1,"")

VBA Noob