
Here's a basic but useful Excel formula. I haven't been blogging much lately so want to create a few helpful posts. Noticed when I was sharing a more complicated formula that some of the smaller pieces might not be well understood.
=DAY(A1)
=DAY(TODAY())
| Date in Cell | Formula | Result |
|---|---|---|
| 1/15/2025 | =DAY(A1) | 15 |
| 12/3/2024 | =DAY(A1) | 3 |
| 6/25/2025 | =DAY(A1) | 25 |
=TEXT(DAY(A1),"00")
If your date is stored as text (like "June 25, 2025"):
=DAY(DATEVALUE(A1))
To get the day from multiple date cells, just change the cell reference:
=DAY(B5) for cell B5=DAY(M2) for cell M2Big agencies bring big-brand experience, and small teams bring agility and a sharp focus on your niche -- Foxco is an Arizona micro agency that gives you both. With 500+ companies and 100+ years of combined experience in competitive markets behind us, you work directly with senior people, get decisions made fast, and get the kind of expert, hands-on execution big agencies just aren't built to deliver.