Forum Discussion
Formula required
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
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.
