This ovulation calendar template was designed to help women who want to have children. The spreadsheet lets you enter the start date of your last period and your average cycle length. Then it estimates future ovulation dates and fertility windows. You can also use it to track actual period and ovulation dates, which may be helpful when consulting a fertility specialist. Read below for information about the assumptions and calculations built into the calendar.


Ovulation Calendar Template

for Excel or Google Sheets
Ovulation Calendar Template


⤓ Excel
For: Excel 2007 or later
⤓ Google Sheets

License: Private Use (not for distribution or resale)

"No installation, no macros - just a simple spreadsheet"



In this calendar, the ovulation date is displayed as dark green and the estimated fertility window is shown as light green.

You can track actual period start dates and ovulation dates by entering the dates manually in the table to the right of the calendar. This can be useful if your cycle is not regular.

IMPORTANT: This ovulation calendar should not be used to prevent pregnancy, because just knowing when you may ovulate is not a reliable birth control method. This calendar should only be used as an aid for women wanting to have children.

Calculating the Ovulation Dates

The ovulation date is generally calculated to be 14 days prior to the start date of your period. The spreadsheet lets you adjust that value if you know it to be different in your case.

Calculating the Fertility Window

This calendar shows the fertility window starting 5 days prior to ovulation [See 1-2]. It is also common for the window to include a day or two after the estimated ovulation date [See 3-4].

Calculating the Due Date

The table to the right of the calendar shows the pregnancy due date calculated to be 266 days after ovulation.

References and Resources

DISCLAIMER: The ovulation calendar and the information on this page should not be used for medical advice, diagnosis, treatment, or in place of professional medical care. Consult a qualified professional for medical care or therapy.