Forum Discussion
waglagla
Nov 09, 2019Copper Contributor
calculate datedif if mutiples conditions within a range are met
Dear Community, hopefully someone can help with the issue I am having. I am trying to calculate the days between a certain date and today's date if multiples conditions are met. =IF(AND(D3:D77="...
Wyn Hopkins
Nov 10, 2019MVP
Hi waglagla
Trying to apply it to a full range in one formula gets tricky and may require an array
Will something like the attached work?
waglagla
Nov 10, 2019Copper Contributor
Thank you for your time Wyn.
Yes its something like the attached work.
The formula Sergei posted worked like a charm.
Yes its something like the attached work.
The formula Sergei posted worked like a charm.