Hi,
I have a data table where there are start and end date specified for each row. I would need to find all those rows where there is any number of days within year 2020 between the start date and end date. My table looks like this:
StartEndDate_table_exaple.jpg
Basically, the only record I'm not interested in is on row 5. I need support in figuring out the best formula to achieve this. Any ideas?
Br, Heini
Bookmarks