Forum Discussion
check if multiple dates are in multiple date ranges
Using 365 one can avoid the need to copy down the formula by referencing entire arrays
= IF(criterion,
(givenDate>=startDate)*(givenDate<=endDate),
"")It looks a bit different, but it would, coming from someone who describes the A1 direct referencing notation as 'an abomination' that has no place in any programming environment.
Thank you for this suggestion. I've never heared about it and based on my recent searches on google about 365 coding or programming is not what you've described above. Can you please share a name or an link? It looks great
The story of modern Excel started with Joe McDaid's announcement in Sept 2018
Preview of Dynamic Arrays in Excel - Microsoft Tech Community.
Later posts include Lambda functions that allow the user to pass parameters into a formula and then some helper functions that pass sequences of parameters into a Lambda function.
The solutions one can develop using the new functionality work at the array level with little requirement for concepts such as relative referencing.
BTW. Without sample results, I may well have misinterpreted the calculation you wish to perform the calculation you wish to perform. More complex situations can involve the '@' operator or even the MAP helper function.
- Amazing. I am very grateful for all the information that you've provided. I will check them and work with them from now on.
Best regards,
Alecs