Sunrise and sunset in Excel

Excel Sunrise, Sunset and Moon in June 2026

Local time (CDT)

Day length goes from 14 h 04 min on June 1 to 14 h 10 min on June 30. Sunrise moves from 5:45 AM to 5:48 AM and sunset from 7:49 PM to 7:58 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
Jun 15:18 AM5:45 AM7:49 PM8:17 PM7:14 PM9:27 PM14 h 04 minWaning gibbous, 98%9:25 PM6:22 AM
Jun 25:18 AM5:45 AM7:50 PM8:18 PM7:15 PM9:27 PM14 h 05 min+1.0 minWaning gibbous, 95%10:12 PM7:14 AM
Jun 35:17 AM5:45 AM7:50 PM8:18 PM7:15 PM9:28 PM14 h 05 min+0.0 minWaning gibbous, 89%10:54 PM8:11 AM
Jun 45:17 AM5:45 AM7:51 PM8:19 PM7:16 PM9:29 PM14 h 06 min+1.0 minWaning gibbous, 81%11:30 PM9:09 AM
Jun 55:17 AM5:45 AM7:51 PM8:19 PM7:16 PM9:29 PM14 h 06 min+0.0 minWaning gibbous, 72%10:07 AM
Jun 65:17 AM5:45 AM7:52 PM8:20 PM7:16 PM9:30 PM14 h 07 min+1.0 minWaning gibbous, 62%12:02 AM11:06 AM
Jun 75:17 AM5:44 AM7:52 PM8:20 PM7:17 PM9:31 PM14 h 08 min+1.0 minLast quarter, 52%12:32 AM12:05 PM
Jun 85:16 AM5:44 AM7:53 PM8:21 PM7:17 PM9:31 PM14 h 09 min+1.0 minLast quarter 5:01 AM1:00 AM1:04 PM
Jun 95:16 AM5:44 AM7:53 PM8:21 PM7:18 PM9:32 PM14 h 09 min+0.0 minWaning crescent, 31%1:27 AM2:05 PM
Jun 105:16 AM5:44 AM7:54 PM8:22 PM7:18 PM9:32 PM14 h 10 min+1.0 minWaning crescent, 22%1:57 AM3:10 PM
Jun 115:16 AM5:44 AM7:54 PM8:22 PM7:19 PM9:33 PM14 h 10 min+0.0 minWaning crescent, 14%2:30 AM4:18 PM
Jun 125:16 AM5:44 AM7:55 PM8:22 PM7:19 PM9:33 PM14 h 11 min+1.0 minWaning crescent, 7%3:08 AM5:31 PM
Jun 135:16 AM5:44 AM7:55 PM8:23 PM7:19 PM9:34 PM14 h 11 min+0.0 minWaning crescent, 3%3:54 AM6:46 PM
Jun 145:16 AM5:44 AM7:55 PM8:23 PM7:20 PM9:34 PM14 h 11 min+0.0 minNew moon 9:54 PM4:50 AM7:58 PM
Jun 155:16 AM5:44 AM7:56 PM8:24 PM7:20 PM9:35 PM14 h 12 min+1.0 minNew moon, 0%5:56 AM9:04 PM
Jun 165:16 AM5:44 AM7:56 PM8:24 PM7:20 PM9:35 PM14 h 12 min+0.0 minWaxing crescent, 2%7:08 AM9:59 PM
Jun 175:17 AM5:45 AM7:56 PM8:24 PM7:21 PM9:35 PM14 h 11 min-1.0 minWaxing crescent, 7%8:22 AM10:44 PM
Jun 185:17 AM5:45 AM7:56 PM8:25 PM7:21 PM9:36 PM14 h 11 min+0.0 minWaxing crescent, 13%9:34 AM11:21 PM
Jun 195:17 AM5:45 AM7:57 PM8:25 PM7:21 PM9:36 PM14 h 12 min+1.0 minWaxing crescent, 21%10:41 AM11:53 PM
Jun 205:17 AM5:45 AM7:57 PM8:25 PM7:21 PM9:36 PM14 h 12 min+0.0 minWaxing crescent, 30%11:44 AM
Jun 215:17 AM5:45 AM7:57 PM8:25 PM7:21 PM9:36 PM14 h 12 min+0.0 minFirst quarter 4:56 PM12:44 PM12:22 AM
Jun 225:17 AM5:46 AM7:57 PM8:25 PM7:22 PM9:37 PM14 h 11 min-1.0 minFirst quarter, 51%1:42 PM12:49 AM
Jun 235:18 AM5:46 AM7:58 PM8:26 PM7:22 PM9:37 PM14 h 12 min+1.0 minWaxing gibbous, 61%2:39 PM1:16 AM
Jun 245:18 AM5:46 AM7:58 PM8:26 PM7:22 PM9:37 PM14 h 12 min+0.0 minWaxing gibbous, 71%3:37 PM1:45 AM
Jun 255:18 AM5:46 AM7:58 PM8:26 PM7:22 PM9:37 PM14 h 12 min+0.0 minWaxing gibbous, 80%4:35 PM2:16 AM
Jun 265:19 AM5:47 AM7:58 PM8:26 PM7:22 PM9:37 PM14 h 11 min-1.0 minWaxing gibbous, 88%5:32 PM2:52 AM
Jun 275:19 AM5:47 AM7:58 PM8:26 PM7:22 PM9:37 PM14 h 11 min+0.0 minWaxing gibbous, 94%6:29 PM3:32 AM
Jun 285:19 AM5:47 AM7:58 PM8:26 PM7:22 PM9:37 PM14 h 11 min+0.0 minWaxing gibbous, 98%7:22 PM4:18 AM
Jun 295:20 AM5:48 AM7:58 PM8:26 PM7:22 PM9:37 PM14 h 10 min-1.0 minFull moon 6:57 PM8:10 PM5:10 AM
Jun 305:20 AM5:48 AM7:58 PM8:26 PM7:23 PM9:37 PM14 h 10 min+0.0 minFull moon, 99%8:53 PM6:05 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.