MarcBeideler
New Member
- Joined
- Jan 26, 2021
- Messages
- 11
- Office Version
- 2016
- Platform
- Windows
Hello,
First of all I want you to apologize my bad english, it's not my first language.
My problem:
I have a list with 3 columns and 100 rows.
Column A category with articles named for example X, Y, Z
Column B containing the entry date of the article
Column C containing the exit date of the article
I need now a formula for a table in witch I could count the article X where the difference between entry and exit date is less or equal 1 year.
Please note the the entry dates are different.
Actually I had a formula in a different column where an IF-formula looked in every row if the conditions are true by giving a result or leaving empty but I thought that it would be better without that additional column.
I've tried with DATE(YEAR()+1,MONTH(),DAY() but it doesn't return a result.
Thanks for your help
Unfortunately it's impossible for me to upload a sheet from my work-computer
First of all I want you to apologize my bad english, it's not my first language.
My problem:
I have a list with 3 columns and 100 rows.
Column A category with articles named for example X, Y, Z
Column B containing the entry date of the article
Column C containing the exit date of the article
I need now a formula for a table in witch I could count the article X where the difference between entry and exit date is less or equal 1 year.
Please note the the entry dates are different.
Actually I had a formula in a different column where an IF-formula looked in every row if the conditions are true by giving a result or leaving empty but I thought that it would be better without that additional column.
I've tried with DATE(YEAR()+1,MONTH(),DAY() but it doesn't return a result.
Thanks for your help
Unfortunately it's impossible for me to upload a sheet from my work-computer