software

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)

=IF(AND(cell_you_checkgt;=$A$1,cell_you_checklt;=$B$1) ,quot;Xquot;,quot;quot;)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;dpatte601quot; gt; wrote in message 45...
gt; Im trying to make a formula that places a X in a week day (Sun - Sat) when
gt; compared to 2 dates.
gt; if A1 is the date 10/05/2006 and B1 is 13/05/2006 then cell C1 is Sunday,
gt; D1 is Monday, E1 is Tue, F1 is Wed, G1 is Thur, H1 is Fri, I1 is
gt; Saturday
gt; lets say Monday is the 10th , Tue is 11th , Wed is 12th and Thur is 13th .
gt; What I want the formula to do is place a X in the dates that corrispond
gt; with 2 dates (A1 and B1) but leavse Blank in the dates not between these.
gt; Any Idea? It to show what days a camp site has some one in it.
gt; thanks for the help I have been tring for 2 weeks to do this (I just
gt; started using Excel)
quot;Peo Sjoblomquot; gt; wrote in news:
:

gt; =IF(AND(cell_you_checkgt;=$A$1,cell_you_checklt;=$B$1) ,quot;Xquot;,quot;quot;)

Thanks this is what i have been looking for all this time, should have
checked here first may have got some sleep for last few weeks. Thanks
again.

Thanks for the feedback

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;dpatte601quot; gt; wrote in message 45...
gt; quot;Peo Sjoblomquot; gt; wrote in news:
gt; :
gt;
gt;gt; =IF(AND(cell_you_checkgt;=$A$1,cell_you_checklt;=$B$1) ,quot;Xquot;,quot;quot;)
gt;
gt; Thanks this is what i have been looking for all this time, should have
gt; checked here first may have got some sleep for last few weeks. Thanks
gt; again.