Forum Discussion

PierreK100's avatar
PierreK100
Copper Contributor
Jan 29, 2023

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 CONFIRM...
Excel
Formulas and Functions
PierreK100's avatar
PierreK100
Copper Contributor

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

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jan 31, 2023
I'm glad I could help you further.
Wish you a lot of fun with Excel :).
  • Dailey0010's avatar
    Dailey0010
    Copper Contributor
    Mar 20, 2024
    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
    • Dailey0010's avatar
      Dailey0010
      Copper Contributor
      Mar 20, 2024

      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

      • SnowMan55's avatar
        SnowMan55
        Bronze Contributor
        Mar 20, 2024

        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.

         

Resources