Im trying to make a formula that places a X in a week day (Sun - Sat) when
compared to 2 dates.
if A1 is the date 10/05/2006 and B1 is 13/05/2006 then cell C1 is Sunday,
D1 is Monday, E1 is Tue, F1 is Wed, G1 is Thur, H1 is Fri, I1 is Saturday
lets say Monday is the 10th , Tue is 11th , Wed is 12th and Thur is 13th .
What I want the formula to do is place a X in the dates that corrispond
with 2 dates (A1 and B1) but leavse Blank in the dates not between these.
Any Idea? It to show what days a camp site has some one in it.
thanks for the help I have been tring for 2 weeks to do this (I just
started using Excel)