Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Rene C
Lv 4
Rene C asked in Computers & InternetSoftware · 8 years ago

How to take a number out of the date (excel)?

I am trying to get the number of the day when the date is written: month/day/year.

For example, 10/22/2013. I want to get the 22 out. I have dates from today back to 1/1/1983 and I need to take out the day. All dates are in the mm/dd/yyyy format

More examples:

1/1/1983: 1

5/30/2000: 30

11/21/2013: 21

1 Answer

Relevance
  • Chris D
    Lv 6
    8 years ago
    Favorite Answer

    DAY()

    So if your date is in the cell A1, then the formula in B1 would be =DAY(A1)

Still have questions? Get your answers by asking now.