I'm working on a sheet that needs some validation. For example, in cell
C4 they are supposed to enter their initials, but some enter their full
name. I need to make sure that they enter (for example) ABC instead of
Alex Billy Charlie.

Then, they are supposed to enter the week ending date in cell K4. I'm
wanting to add a calendar there, so they can select the date. However,
I only want my calendar to show week ending Saturdays, or make it so
when they select any day in that week, it selects that weeks Saturday.
Then, when they enter the date, it will automatically fill in
information in G10 (Sunday), G21 (Monday), G46 (Tuesday), G71
(Wednesday), etc... This will be the rest of the days in that
particular week..


example:
Enter date 06-18-05 in cell K4
G10 = 06-12-05
G21 = 06-13-05
G46 = 06-14-05
G71 = 06-15-05.... etc....




Sorry if the description is vague...Thanks in advance for any help!!


DejaVu


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