Forum Discussion
Formula required
I am trying to do a gestation calculator for pigs and need formula for my final farrowing date if the sow does not go for rebreed
| SOW NUMBER | HEAT DETECTEION DATE | SERVICE DATE | PREGNANCY CONFIRMATION DATE | REBREED YES/NO | REBREED DATE | PREGNANCY CONFIRMATION DATE | APPROXIMATE FARROWING DATE | |
| C&P 2201 | 25-Jan-23 | 27-Jan-23 | 17-Feb-23 | Y | 19-Feb-23 | 9-Mar-23 |
So sow goes for servicing on 27/01/23, 3 weeks later she is checked for heat, if she does not come into heat 27/01/2023 will be her service date and farrowing date will be 114 days from this date. However if she does come into heat she is returned to the boar and checked for heat 3 weeks later. if she does not come into heat 19/02/2023 will be used as service date and the farrowing date will be calculated from this date. Please help
Attached is a file with an example...as far as I understood it 🙂
Hope I could help you with this exmble file.
I know I don't know anything (Socrates)
NikolinoDE thank you very much. Your formula works, just had to swap the Yes and No around. Thank you once again
- I'm glad I could help you further.
Wish you a lot of fun with Excel :).
