days between 2 dates
 

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)

days between 2 dates
 

=IF(AND(cell_you_check=$A$1,cell_you_check<=$B$1) ,"X","")

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"dpatte601" wrote in message
45...
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)

days between 2 dates
 

"Peo Sjoblom" wrote in news:
:

=IF(AND(cell_you_check=$A$1,cell_you_check<=$B$1) ,"X","")

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.

days between 2 dates
 

Thanks for the feedback

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"dpatte601" wrote in message
45...
"Peo Sjoblom" wrote in news:
:

=IF(AND(cell_you_check=$A$1,cell_you_check<=$B$1) ,"X","")

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.