MOONPHASE

Returns the moon phase of a specific date.

The MOONPHASE function can calculate the moonphase of a date, and represents each of the moon phases using an integer. New Moon , Quarter, Full Moon, ThreeQuarter, or None (no special day).

Moonphase
Value
None (no special day)
0
New Moon
1
Quarter
2
Full Moon
3
Three-Quarter
4

Syntax

MOONPHASE(Date)

Date is the date to be considered.

Example

Date
Answer
Description
26-May-04
2
Quarter
2-Jun-04
3
3 Full Moon