Selecting data within a date range

M

mtaylor

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 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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count a value in a date range based on a date in another workshee. 4
date range within a date range 2
Colors according to the month 3
2 dimensional date sort 1
IF - Date falls between two dates, place here 3
Help Calculating Time 5
Find match between cells and copy data 7
Save value of cell prior to change 2

Top