Sunrise and sunset in Excel

Excel Sunrise, Sunset and Moon in May 2026

Local time (CDT)

Day length goes from 13 h 25 min on May 1 to 14 h 03 min on May 31. Sunrise moves from 6:04 AM to 5:46 AM and sunset from 7:29 PM to 7:49 PM.

Every day

Dawn and dusk are civil twilight (the sun 6 degrees below the horizon); golden hour starts when the evening sun is 6 degrees up; full dark is astronomical twilight, 18 degrees down. A blank moonrise or moonset means it falls on the next day.

DateDawnSunriseSunsetDuskGolden hourFull darkDay lengthChangeMoonMoonriseMoonset
May 15:38 AM6:04 AM7:29 PM7:55 PM6:56 PM8:58 PM13 h 25 minFull moon 12:24 PM7:48 PM5:41 AM
May 25:37 AM6:03 AM7:30 PM7:56 PM6:56 PM8:59 PM13 h 27 min+2.0 minFull moon, 99%8:47 PM6:15 AM
May 35:37 AM6:02 AM7:30 PM7:56 PM6:57 PM9:00 PM13 h 28 min+1.0 minWaning gibbous, 97%9:44 PM6:53 AM
May 45:36 AM6:02 AM7:31 PM7:57 PM6:58 PM9:01 PM13 h 29 min+1.0 minWaning gibbous, 92%10:39 PM7:37 AM
May 55:35 AM6:01 AM7:32 PM7:58 PM6:58 PM9:02 PM13 h 31 min+2.0 minWaning gibbous, 85%11:30 PM8:26 AM
May 65:34 AM6:00 AM7:33 PM7:59 PM6:59 PM9:03 PM13 h 33 min+2.0 minWaning gibbous, 77%9:20 AM
May 75:33 AM5:59 AM7:33 PM7:59 PM6:59 PM9:04 PM13 h 34 min+1.0 minWaning gibbous, 67%12:15 AM10:17 AM
May 85:32 AM5:58 AM7:34 PM8:00 PM7:00 PM9:05 PM13 h 36 min+2.0 minLast quarter, 57%12:55 AM11:16 AM
May 95:31 AM5:57 AM7:35 PM8:01 PM7:01 PM9:06 PM13 h 38 min+2.0 minLast quarter 4:11 PM1:30 AM12:15 PM
May 105:30 AM5:57 AM7:35 PM8:02 PM7:01 PM9:07 PM13 h 38 min+0.0 minWaning crescent, 36%2:02 AM1:15 PM
May 115:29 AM5:56 AM7:36 PM8:02 PM7:02 PM9:08 PM13 h 40 min+2.0 minWaning crescent, 26%2:31 AM2:16 PM
May 125:29 AM5:55 AM7:37 PM8:03 PM7:03 PM9:09 PM13 h 42 min+2.0 minWaning crescent, 17%3:00 AM3:18 PM
May 135:28 AM5:54 AM7:37 PM8:04 PM7:03 PM9:10 PM13 h 43 min+1.0 minWaning crescent, 10%3:29 AM4:22 PM
May 145:27 AM5:54 AM7:38 PM8:05 PM7:04 PM9:11 PM13 h 44 min+1.0 minWaning crescent, 5%4:01 AM5:31 PM
May 155:26 AM5:53 AM7:39 PM8:05 PM7:04 PM9:12 PM13 h 46 min+2.0 minWaning crescent, 1%4:37 AM6:43 PM
May 165:26 AM5:52 AM7:39 PM8:06 PM7:05 PM9:13 PM13 h 47 min+1.0 minNew moon 3:02 PM5:19 AM7:58 PM
May 175:25 AM5:52 AM7:40 PM8:07 PM7:06 PM9:14 PM13 h 48 min+1.0 minWaxing crescent, 1%6:11 AM9:13 PM
May 185:24 AM5:51 AM7:41 PM8:08 PM7:06 PM9:15 PM13 h 50 min+2.0 minWaxing crescent, 4%7:11 AM10:22 PM
May 195:24 AM5:51 AM7:41 PM8:08 PM7:07 PM9:15 PM13 h 50 min+0.0 minWaxing crescent, 10%8:19 AM11:21 PM
May 205:23 AM5:50 AM7:42 PM8:09 PM7:07 PM9:16 PM13 h 52 min+2.0 minWaxing crescent, 17%9:31 AM
May 215:23 AM5:50 AM7:43 PM8:10 PM7:08 PM9:17 PM13 h 53 min+1.0 minWaxing crescent, 26%10:42 AM12:10 AM
May 225:22 AM5:49 AM7:43 PM8:10 PM7:09 PM9:18 PM13 h 54 min+1.0 minWaxing crescent, 35%11:50 AM12:50 AM
May 235:22 AM5:49 AM7:44 PM8:11 PM7:09 PM9:19 PM13 h 55 min+1.0 minFirst quarter 6:11 AM12:53 PM1:23 AM
May 245:21 AM5:48 AM7:45 PM8:12 PM7:10 PM9:20 PM13 h 57 min+2.0 minFirst quarter, 56%1:53 PM1:53 AM
May 255:21 AM5:48 AM7:45 PM8:13 PM7:10 PM9:21 PM13 h 57 min+0.0 minWaxing gibbous, 67%2:51 PM2:20 AM
May 265:20 AM5:47 AM7:46 PM8:13 PM7:11 PM9:22 PM13 h 59 min+2.0 minWaxing gibbous, 76%3:48 PM2:46 AM
May 275:20 AM5:47 AM7:46 PM8:14 PM7:11 PM9:23 PM13 h 59 min+0.0 minWaxing gibbous, 85%4:45 PM3:14 AM
May 285:19 AM5:47 AM7:47 PM8:14 PM7:12 PM9:23 PM14 h 00 min+1.0 minWaxing gibbous, 91%5:42 PM3:43 AM
May 295:19 AM5:46 AM7:48 PM8:15 PM7:13 PM9:24 PM14 h 02 min+2.0 minWaxing gibbous, 96%6:40 PM4:15 AM
May 305:18 AM5:46 AM7:48 PM8:16 PM7:13 PM9:25 PM14 h 02 min+0.0 minFull moon, 99%7:38 PM4:52 AM
May 315:18 AM5:46 AM7:49 PM8:16 PM7:14 PM9:26 PM14 h 03 min+1.0 minFull moon 3:46 AM8:33 PM5:34 AM

Other months

More

Sources

Computed with the NOAA solar position equations and the lunar methods of Meeus, Astronomical Algorithms, for a flat horizon; hills and buildings delay a real sunrise.