Selecting data within a date range

Can you please help!?

I have numerical data within 3 cells x,y & z

I then have a separate cell (a) which i need to display either the info in cells x,y & z depending on the date.

For example:-
I need the info in cell x to be displayed in cell 'a' between 01/09/05 and 10/09/05
I need the info in cell y to be displayed in cell 'a' between 11/09/05 and 13/09/05
I need the info in cell z to be displayed in cell 'a' between 14/09/05 and 19/09/05

The date the sheet is accessed (TODAY) will determine what info is displayed in cell 'a'.

Is it possible to create a formula for this?

Thanks

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>

I am not sure what cell you want to test to be between those dates, so I
have assumed B1 in this formula

=IF(B1<=TODAY()+9,X1,IF(B1<=TODAY()+12,Y1,IF(B1<=TODAY()+18,Z1,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mtaylor" <[email protected]> wrote in
message news:[email protected]...
>
> Can you please help!?
>
> I have numerical data within 3 cells x,y & z
>
> I then have a separate cell (a) which i need to display either the info
> in cells x,y & z depending on the date.
>
> For example:-
> I need the info in cell x to be displayed in cell 'a' between 01/09/05
> and 10/09/05
> I need the info in cell y to be displayed in cell 'a' between 11/09/05
> and 13/09/05
> I need the info in cell z to be displayed in cell 'a' between 14/09/05
> and 19/09/05
>
> The date the sheet is accessed (TODAY) will determine what info is
> displayed in cell 'a'.
>
> Is it possible to create a formula for this?
>
> Thanks
>
>
> --
> mtaylor
> ------------------------------------------------------------------------
> mtaylor's Profile:
http://www.excelforum.com/member.php...o&userid=26871
> View this thread: http://www.excelforum.com/showthread...hreadid=401084
>