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
cfinck Posts 3 Registration date Friday July 29, 2016 Status Member Last seen July 29, 2016 - Jul 29, 2016 at 12:01 PM
Related:
- Function date range specific cells if & date formula?
- Date formula in excel dd/mm/yyyy - Guide
- Position formula in excel ✓ - Office Software Forum
- If cell contains date then return value ✓ - Office Software Forum
- Logitech formula vibration feedback wheel driver - Download - Drivers
- How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
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
Jul 29, 2016 at 10:11 AM
cfinck, Good morning.
Sorry, I'm not understanding your necessity and your layout.
Please, save your file at a free site, www.speedyshare.com, and put link here to download.
Display there your desired results.
It will be easier for us to help you conclusively.
Sorry, I'm not understanding your necessity and your layout.
Please, save your file at a free site, www.speedyshare.com, and put link here to download.
Display there your desired results.
It will be easier for us to help you conclusively.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 29, 2016 at 11:50 AM
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.
We're just trying to help you use Excel functions for you to succeed in your job.
I hope you understand our request.
Have a nice day.
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.
We're just trying to help you use Excel functions for you to succeed in your job.
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
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.
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.
Jul 29, 2016 at 10:47 AM
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.