Forum Discussion

gehcole's avatar
gehcole
Copper Contributor
Mar 07, 2024

Excel formula, conditional date

Tengo 250 plantas diferentes que necesitan riego en intervalos de días diferentes según la estación y la planta. Hay dos estaciones: ene, feb, abr, nov, dic mar, may, jun, jul, ago, sep, oct Co...
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Mar 07, 2024

gehcole 

Try this one:

=LET(
    r, SEQUENCE(ROWS(LastWatered)),
    c, XMATCH("*" & TEXT(LastWatered, "mmm") & "*", season, 2),
    INDEX(WateringFreq, r, c) + LastWatered
)
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Mar 07, 2024

    Patrick2788 

    Works well.  You could 'pretty up' the wildcards by including them in the text format.

     

  • gehcole's avatar
    gehcole
    Copper Contributor
    Mar 07, 2024

    Patrick2788 Thanks, this example may make the problem clearer. Please note that all data are filled in by hand.

Resources