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.
