Forum Discussion
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...
A formula such as
= LET(
isSeason1?, ISNUMBER(XMATCH(MONTH(LastWatered), season1)),
LastWatered + IF(isSeason1?, Freq1, Freq2)
)would give the next date. The catch is that then you may need the second and the third dates.
This example makes it easier?
