Returns the time of sunset on a specified date.
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.
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
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