•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
Our take
Are you struggling to identify the number of missing days between overlapping start and end dates in extensive spreadsheet columns? You’re not alone—this common challenge can lead to confusion and inefficiency. Thankfully, there’s a straightforward solution using AI-native spreadsheet technology that simplifies this process. By leveraging advanced functions, you can effortlessly calculate the number of missing days without getting bogged down by complex data. Read on to discover how to streamline your analysis and gain valuable insights from your date ranges with ease.
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]
Read on the original site
Open the publisher's page for the full experience