•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
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#real-time data collaboration
#intelligent data visualization
#missing days
#date range
#start date
#end date
#data overlap
#DD-MM-YYYY
#date format
#columns range
#count missing
#6 days