Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
challenging formula(for me), counting days between dates for multipleyears | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Brainteaser about Days Between Dates | Excel Discussion (Misc queries) | |||
how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
Subracting Dates to come up with the # of days between them | Excel Worksheet Functions |