I need the green box to display the next estimated heat cycle date based off the average between the dates entered into the blue boxes. Need it to calculate the next estimated heat date weather there is 2 dates enter or all cells entered.
In the prefect scenario it would be really nice if it calculated the next estimated heat date off just the first entry with 180 days expected for the next heat date then after 2 or more entries it started calculating next heat date off of the average between dates. If this is not possible and just an average expected next heat after 2 or more entries will be fine.
Hello, I can help you with the calculation. Yes, it can be done in the first entry date. I am available now, feel free to message me anytime. Thank you John