# Selecting data within a date range

mtaylor
Guest
Posts: n/a

 1st Sep 2005

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

I then have a separate cell (a) which i need to display either the inf
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/0
and 10/09/05
I need the info in cell y to be displayed in cell 'a' between 11/09/0
and 13/09/05
I need the info in cell z to be displayed in cell 'a' between 14/09/0
and 19/09/05

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

Is it possible to create a formula for this?

Thank

--
mtaylo
-----------------------------------------------------------------------
mtaylor's Profile: http://www.excelforum.com/member.php...fo&userid=2687

Bob Phillips
Guest
Posts: n/a

 1st Sep 2005
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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
>
> 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
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post MoonBlosm Microsoft Excel Misc 2 17th Jul 2009 11:09 AM =?Utf-8?B?cHJvZw==?= Microsoft Excel Programming 1 10th Aug 2007 08:48 PM leelondon Microsoft Excel Discussion 5 4th Oct 2006 12:12 PM hansiman Microsoft Excel Discussion 1 24th Feb 2005 01:21 AM Steven Reid Microsoft Excel Worksheet Functions 5 17th Jun 2004 12:29 AM

Features