•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sum number of days between given date range that overlap with another date range
Hello,
I'm sorry if this post sounds confusing, as english is not my first language.
I am trying to make an excel formula which counts how many days are within two overlaping date ranges (Minimun date with Maximum date and First day with Last day), because the target sheet has hundreds of lines.
I am a bit desperate and i've tried nested IFs:
=IF(B4>=$C$1;IF(AND(B4<>D4;$E$1-D4<0);$E$1-B4+1;IF(AND(B4>$C$1;B4>$E$1);0;C4)))
But i've failed when the First day column has a date bigger than the Minimun day and i am quite lost.
Dates are in the dd/mm/yyyy format.
Is there a way to solve this without having to manually do it?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#natural language processing
#formula generator
#date range
#overlapping
#count
#Excel formula
#days
#minimum date
#maximum date
#first day
#last day
#nested IFs
#manual