Sunrise and sunset in Excel

Excel Sunrise, Sunset and Moon in July 2026

Local time (CDT)

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