Formula required

[PierreK100]

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

[#2]

@PierreK100 

Attached is a file with an example...as far as I understood it 🙂

Hope I could help you with this exmble file.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

@NikolinoDE thank you very much. Your formula works, just had to swap the Yes and No around. Thank you once again

[#4]

I'm glad I could help you further.
Wish you a lot of fun with Excel :).

[#5]

@PierreK100 Im looking to make a yearly calendar for pig gestation and heat date with this exact info. How can I do a formula that does this for everyday 

[#6]

Im looking to make a yearly calendar for pig gestation and heat date with this exact info. How can I do a formula that does this for everyday

[#7]

I'm looking to do a generic printable calendar with all this info on everyday. The pigs heat cycle is every 21 days because that the heat cycle. I'm looking for if I breed her on this
Breed Jan 1st
Heat Cycle Jan 22nd
Due date 10/10/24

Breed Jan 2nd
Heat cycle 1-23-24
Due Date 10-11-24

Breed Jan 3rd
Heat Cycle 1-24-24
Due 10-12-25

This is the info I want on everyday to continue until Dec 31 on a printable calendar. How would I change this for 2025? We write gilts name on the calendar who is in heat and who is due.

The formula you did for Pierrek100 is that like a actual spreadsheet? That might be helpful as well to have a digital copy and a hard copy

[#8]

@Dailey0010 

See the attached workbook for two possibilities. Each shows a one-month calendar; the month can be changed by using a dropdown list (click on the month name to show the dropdown arrow) and a cell entry (for the year). Formulas in odd-numbered rows in those two worksheets determine what day number to display, and different formulas in the even-numbered rows determine what associated text to display.

A full-year calendar is also possible with additional work, but I already had one-month calendars similar to this.

For more information, read the _Info worksheet.