I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column c1
falls between those dates, I want to have the cell in D1 enter the value of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura

With
A1: (a start date)
B1: (an end date)
C1: (a date)

This formula returns 1 if C1 is between A1 and B1, inclusive:
D1: =--(MEDIAN(A1:C1)=C1)

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Laura Logan" wrote in message
...
I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column c1
falls between those dates, I want to have the cell in D1 enter the value
of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura

Thanks Ron. That did the trick.
--
Laura


"Ron Coderre" wrote:

With
A1: (a start date)
B1: (an end date)
C1: (a date)

This formula returns 1 if C1 is between A1 and B1, inclusive:
D1: =--(MEDIAN(A1:C1)=C1)

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Laura Logan" wrote in message
...
I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column c1
falls between those dates, I want to have the cell in D1 enter the value
of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura

Sorry, question should read:

I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column c1
falls between those dates, I want to have the cell in D1 enter the value of
1. If c1 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura


"Laura Logan" wrote:

I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column c1
falls between those dates, I want to have the cell in D1 enter the value of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura

Perhaps this is easier to understand rather than that obfuscated formula.

=IF(AND(C1=A1,C1<=B1),1,0)

Tyro

"Laura Logan" wrote in message
...
I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column c1
falls between those dates, I want to have the cell in D1 enter the value
of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura

How about this:

=AND(C1=A1,C1<=B1)*1

Obfuscated enough ?

Pete

"Tyro" wrote in message
. net...
Perhaps this is easier to understand rather than that obfuscated formula.

=IF(AND(C1=A1,C1<=B1),1,0)

Tyro

"Laura Logan" wrote in message
...
I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column
c1
falls between those dates, I want to have the cell in D1 enter the value
of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura

Apply the KISS principle, just keep it simple

Tyro

"Pete_UK" wrote in message
...
How about this:

=AND(C1=A1,C1<=B1)*1

Obfuscated enough ?

Pete

"Tyro" wrote in message
. net...
Perhaps this is easier to understand rather than that obfuscated formula.

=IF(AND(C1=A1,C1<=B1),1,0)

Tyro

"Laura Logan" wrote in message
...
I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column
c1
falls between those dates, I want to have the cell in D1 enter the value
of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura

You have really no understanding of simple things. The more obfuscated it
is, the better for the learner.
I can give you obfuscated things that would blow your socks off. But to
whose benefit?

Tyro

"Pete_UK" wrote in message
...
How about this:

=AND(C1=A1,C1<=B1)*1

Obfuscated enough ?

Pete

"Tyro" wrote in message
. net...
Perhaps this is easier to understand rather than that obfuscated formula.

=IF(AND(C1=A1,C1<=B1),1,0)

Tyro

"Laura Logan" wrote in message
...
I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column
c1
falls between those dates, I want to have the cell in D1 enter the value
of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura

Well, the OP here thanked Ron for his formula, so presumably she
understood it in the end. Sometimes it is better to stretch knowledge
in order for the learner to gain a better understanding of the
solution.

Pete

On Mar 12, 12:20*am, "Tyro" wrote:
You have really no understanding of simple things. The more obfuscated it
is, the better for the learner.
I can give you obfuscated things that would blow your socks off. But to
whose benefit?

Tyro

"Pete_UK" wrote in message

...



How about this:

=AND(C1=A1,C1<=B1)*1

Obfuscated enough ?

Pete

"Tyro" wrote in message
.net...
Perhaps this is easier to understand rather than that obfuscated formula.

=IF(AND(C1=A1,C1<=B1),1,0)

Tyro

"Laura Logan" wrote in message
...
I am trying to create a function in a spreadsheet but not sure how to go
about it. *I have a start date in A1 and and end date in B1. *If column
c1
falls between those dates, I want to have the cell in D1 enter the value
of
1. *If c2 does not fall between those dates, then I want it to enter the
value of 0. *Can this be done?
--
Laura- Hide quoted text -

- Show quoted text -

I disagree entirely. The OP needs to learn the simple things, complicated
(obfuscation) will come with time.
After 44 years of computer programming, I truly believe in keeping it
simple.
I can obfuscate to the point that most programmers will say what is this
that works?

Tyro

"Pete_UK" wrote in message
...
Well, the OP here thanked Ron for his formula, so presumably she
understood it in the end. Sometimes it is better to stretch knowledge
in order for the learner to gain a better understanding of the
solution.

Pete

On Mar 12, 12:20 am, "Tyro" wrote:
You have really no understanding of simple things. The more obfuscated it
is, the better for the learner.
I can give you obfuscated things that would blow your socks off. But to
whose benefit?

Tyro

"Pete_UK" wrote in message

...



How about this:

=AND(C1=A1,C1<=B1)*1

Obfuscated enough ?

Pete

"Tyro" wrote in message
.net...
Perhaps this is easier to understand rather than that obfuscated
formula.

=IF(AND(C1=A1,C1<=B1),1,0)

Tyro

"Laura Logan" wrote in message
...
I am trying to create a function in a spreadsheet but not sure how to
go
about it. I have a start date in A1 and and end date in B1. If column
c1
falls between those dates, I want to have the cell in D1 enter the
value
of
1. If c2 does not fall between those dates, then I want it to enter
the
value of 0. Can this be done?
--
Laura- Hide quoted text -

- Show quoted text -