Search
Generic filters

Moon Phase Calendar Landscape Excel Template

The Moon Phase calendar Landscape templates on this page use a table of Moon phase times. To display Full Moon, New Moon, and the other major phases in yearly or monthly calendar formats. These calendars use special Unicode characters shown in the table to the right. How these symbols appear on your computer depends on the browser and the device you are using. Whether you are using desktop version of Excel or Excel Online.

This Moon Phase Calendar Landscape allow to choose a year and start month as well as a UTC offset (to show phases based on a specific time zone), but table of Moon Phases in these spreadsheets only includes the years 2017-2030.

Moon calendar

Conditional Formatting is use to display moon phase Unicode characters by modifying the custom number format. The formulas use for the conditional formatting rules use a lookup function that compares the date against a table of moon phases.

Moon Phase Today

The dates and times for moon phases listed in these spreadsheets come from the U.S. Naval Observatory website and are listed in UTC time. The templates allow to choose a UTC offset to display the phases in a time zone closer to you (the default is UTC-7).

The exact time of Moon phase is based on the position of the Moon and Sun relative to the Earth, not the observer’s position on Earth. Moreover, This means that if the time of a Full Moon is listed as “Jan 12, 2017 at 11:34 AM UTC time” only the people on the night side of Earth will see the moon at the time that it is exactly 100% full. However, People in England on Jan 12, 2017 would not be able to see a 100% Full Moon.

Lunar Calendar

Furthermore, The naked eye cannot easily tell the difference between a 95% Full Moon and a 100% Full Moon. So the Moon will appear to be full for about 3 nights.

Thus, The exact time is not display in the calendar. So you may not know whether the phase occurs in the morning or evening. For most casual uses that won’t make much difference. Therefore you need the exact Moon phase times, consult an authoritative website like the U.S. Naval Observatory mentioned above.

Also, In these spreadsheets, the times for the waxing crescent, waxing gibbous, waning gibbous, and waning crescent are approximate by calculating the date/time in between the 4 major phases. So, We felt this was a sufficient approximation for displaying these phases in a calendar.

Download Moon Phase Calendar Landscape Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: