Calculate with MONTH

Eric Laitenberger

Hello,

With this formula I can not calculate the number of days if the Month is superior or equal to "10"

=IF(AND([Mois fin]@row = "3", [Mois début]@row = "3"), [Fin incapacité]@row - [Début incapacité]@row + 1, IF(AND([Mois fin]@row > "3", [Mois début]@row = "3"), {DATE METRIC Range 1} - [Début incapacité]@row + 1, IF(AND([Mois fin]@row > "3", [Mois début]@row < "3"), {DATE METRIC Range 1} - {DATE METRIC Range 6} + 1, IF(AND([Mois fin]@row = "3", [Mois début]@row < "3"), [Fin incapacité]@row - {DATE METRIC Range 6} + 1, ""))))

Could you help me

Genevieve P.

Hi @Eric Laitenberger

The formula won't be able to calculate because you have the number 3 in quotes, which turns it into text (instead of a number). This means the formula can't check what's > "3", in the same way it can't check whats > "text".

Is the [Mois fin] column a date column or a text/number column? Can you post a screen capture of your sheet?

Cheers,

Genevieve

Eric Laitenberger

I found Thanks