•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Find a number of missing days from two columns range
Is there any way to find a number of missing days (no need for specific dates listed) based on two columns range - start date and end date?
In this case that would be 6 days (27JAN - 1FEB), but the columns would be much more extensive.
The biggest problem is that the data can overlap and start date can be sooner than end date from higher cell.
Format is DD-MM-YYYY
[link] [comments]
Want to read more?
Check out the full article on the original site