You could use data|validation like:

=WEEKDAY(A1)=6

But if you want that calendar, take a look at Ron de Bruin's site for some
tips/code/free calendar control:
http://www.rondebruin.nl/calendar.htm

But why not just let the user type what they want and use that other cell to get
the associated Friday?



DejaVu wrote:

Dave, I have another question for you.

I have several cells that come from the value of cell K4. For example,
the other cells have formulas like:
=IF($K$4="","",$K$4-6)
=IF($K$4="","",$K$4-5)
..etc

In cell K4, they are supposed to enter the week ending Saturday,
because each of the following cells depend on that date. I'm wondering
what is the best way to make sure that they enter a Saturday? Right
now, I have the cell formatted as dddd mm/dd/yyyy.

Should I add a drop down calendar to this cell?

Thanks again for all your help Dave!!

DejaVu

--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=380088

--

Dave Peterson