Forum Discussion
Date Formatting
I would like some assistance creating a date formula. What i require is the following. Planting Date: eg- 01-01-2019 (entered as a date that a crop was planted) Growing Days: (if i set this as a =...
Do you have a harvest date field?
=If(HarvestDate=“”,Today(),HarvestDate)-PlantDate
Or I’d there is a maximum number of growing days (e.g 90), you could:
=PlantDate+Min(Today()-PlantDate,90)
=If(HarvestDate=“”,Today(),HarvestDate)-PlantDate
Or I’d there is a maximum number of growing days (e.g 90), you could:
=PlantDate+Min(Today()-PlantDate,90)
