SUNSET

Returns the time of sunset on a specified date.

Syntax

SUNSET(year_input, month_input, day_input, longitude, latitude, TZ, is_daylight_saving)

year_input is the 4-digit year of the date to consider
month_input is the month of the date to consider
day_input is the day of the month date to consider
longitude is a numerical value representing the longitude of the location to be considered. (negative values for West)
latitude is a numerical value representing the latitude of the location to be considered.
TZ Optional. A numerical offset from UTC (at the local site)
SUNRISE can give more accurate answer if the exact value for TZ can be provided. If TZ is omitted, the function will attempt to use a best estimation based on built-in algorithm.
is_daylight_saving Optional. Boolean argument, either TRUE or FALSE. Decides whether Daylight Savings Time is in effect. Default is FALSE if omitted.


Remark

It is mathematically possible that a certain location on Earth has no sunset on a particular date. In such case, SUNSET function will return the answer “No sunset”.

There are various sources on the Internet where you can find longitude and latitude information. A good resource is : http://www.calle.com/world/index.html

Example

Below shows the calculations for sunrise times for New York and Japan on February 1st 2005.

City
Longitude
Latitude
SUNRISE Function
Answer
New York
-78.79
42
=SUNSET(2005,2,1,-78.79,42)
5:26PM
Tokyo
139.75
35.68
=SUNSET(2005,2,1,139.75,35.68)
5:05PM

See Also:

SUNRISE
SUNTIMES
UTCOFFSET