Forum Discussion

waglagla's avatar
waglagla
Copper Contributor
Nov 09, 2019

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="...
Formulas and Functions
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Nov 10, 2019

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's avatar
    waglagla
    Copper Contributor
    Nov 10, 2019
    Thank you for your time Wyn.
    Yes its something like the attached work.
    The formula Sergei posted worked like a charm.

Resources