meeting count

[pbruyere]

Hello, in the attached file, I would like to have the number of days returned in cell D10 the number of days between the x found in that row and the today's date in cell D7.

Thank you for your help.

[63falcondude]

Try this:

=D$7-INDEX(E$8:NM$8,MATCH("x",E10:NM10,0))

Format as General

[pbruyere]

hello, it did not work, i got an error message

[63falcondude]

Works on my end.

If your regional settings require ; instead of , then you will have to use ; in the formula.

[pbruyere]

Hello,So I did change the commas for ; and it works.

I would like to change the negative answer to positive, meaning to have it say, the meeting will be in 5 days intead of -5, and also have a zero when there are no x.

I have attached the file.

Pascale

[63falcondude]

In your original workbook from post #1, the date in cell D7 always came after the dates for the x's.

In your sample from post #5, the date in D7 comes before the dates for the x's.

Does this mean that in your actual file, the date in D7 can either come before or after the dates with the x's and that both cases should show as positive?

If so, you can use this in D10:

=IFERROR(ABS(D$7-INDEX(E$8:NM$8;MATCH("x";E10:NM10;0)));0)

[pbruyere]

Perfect, that formula worked. case closed.

Pascale

[63falcondude]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.