# Function date range specific cells if & date formula?

Closed
cfinck Posts 3 Registration date Friday July 29, 2016 Status Member Last seen July 29, 2016 - Jul 29, 2016 at 09:31 AM
cfinck Posts 3 Registration date Friday July 29, 2016 Status Member Last seen July 29, 2016 - Jul 29, 2016 at 12:01 PM
I need to be able to pull data(other cells in the row) from a specific date range.

My current formulas still need to be expressed but I only need it from certain dates so I can accumulate the data from a range.

Example: the date range is 5/1/2016 to 5/31/2016
Row DP4 : DP69

The first formula is
=iferror(c4/b4,0)

2nd
=if(b4,((b4-c4)/b4),0)

3rd
=iferror=(d4/b4,0)

4th
=if(b4,((c4+d4)/b4),0)

I keep trying to see how I can make this possible but I can't seem to get it. Any help would be appreciated.

Thank you.

## 2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 29, 2016 at 10:11 AM
cfinck, Good morning.

cfinck Posts 3 Registration date Friday July 29, 2016 Status Member Last seen July 29, 2016
Jul 29, 2016 at 10:47 AM
Thanks. Here's a mock up of my data.

http://speedy.sh/z8eQ8/Form.xlsx

I need to pull only the date with these formulas in a specific date range, so only May 2016 and only June, ect. But when I try to use the date function with a range of cells for that date range, I get an error .

Thank you so much for your help.
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 29, 2016 at 11:50 AM
cfinck, Good afternoon.

Thanks for example.

Still could not understand your need.
The sheet is filled with formulas and all of them are working.

Please, enter manually with the data the way they should appear on your expected outcome.
Give us a practical example.

Remember that you have total command over the knowledge of the data.
I hope you understand our request.

Have a nice day.
cfinck Posts 3 Registration date Friday July 29, 2016 Status Member Last seen July 29, 2016
Jul 29, 2016 at 12:01 PM
Hi,

I'm sorry about that. I am pulling data from all the cells in my workbook currently. I need to be more specific on which cells are included (by monthly date range). I need to have the formulas I am currently using but only for the rows with dates for a month. My working spreadsheet has 4000 rows.

Using the sort and filter option does not help me because I need the calculations to only pull per month as opposed to over all.

I remember being able to pull data from rows with certain dates and excluding all others but I can't get my formula to incorporate the date & if or if error functions properly.

What I tried is
=if((date>05/01/16,date<05/31/16,d2:d6,0)b4((c4+d4))/b4,0)

So I have not been able to ask the spreadsheet to only pull data from the rows within the month date range I selected.