Date Ranges Help

[gazza9797]

Hi,
I need help with the following.
I would would like to search a cell for date range and then retreive information from another cell.

eg:
If the Date of a cell is within the month of March, then the cell will retrieve information from another cell and display it.

A1 03/1/2018 B1 $1,000

If A1 falls within the month of March then display B1. And so on I will need to do this for each month.


thanks!

 

[My Aswer Is This]

What do you mean "Display" B1

B1 is always displayed. You cannot hide and display cells.

And you want us to search down Column "A" for Each Month of the current year.

The big question is display this data where:

Normally we say copy this data some place.

So where do we copy January
Where do we copy February and on and on.

 

[gazza9797]

A1 03/1/2018 B1 $1,000

C1 = If A1 falls within the month of March then Retrieve B1

 

[kvsrinivasamurthy]

Try this

=IF(Month(A1)=3,B1,"")

 

[gazza9797]

Try this

=IF(Month(A1)=3,B1,"")

That works, Ok, Now I want to do a range of Cells.

eg:

=IF(Month(A1:A5)=3,B1:5,"")

However this returns a blank cell.

 

[admiral100]

Hi,

Do you mean to sum all cells in column B that are in the date range eg March?