ExcelBanter - day of month

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - day of month (https://www.excelbanter.com/excel-worksheet-functions/159988-day-month.html)

scotty

day of month

What formula will return the day of month, if I have the date in a cell
(example 11/23/07), I need only the 23.

Thanks

scotty

day of month

I found the answer (=DAY)

"Scotty" wrote:

What formula will return the day of month, if I have the date in a cell
(example 11/23/07), I need only the 23.

Thanks

David Biddulph[_2_]

day of month

Did you think of typing DAY into Excel help?
--
David Biddulph

"Scotty" wrote in message
...
What formula will return the day of month, if I have the date in a cell
(example 11/23/07), I need only the 23.

Thanks

All times are GMT +1. The time now is 05:25 AM.