对于日期列表，您知道如何提取或获取年，月和日的编号吗？ 请参见下面的屏幕截图。 在本文中，我们将向您展示从Excel中的日期列表中分别获取年，月和日编号的公式。
2.复制并粘贴公式 =年（A2） 进入公式栏，然后按 输入 键。 将“填充手柄”向下拖动到您需要从列表中获取所有年份的范围。
1.选择一个空白单元格，复制并粘贴公式 = MONTH（A2） 进入公式栏，然后按 输入 键。
复制并粘贴公式 = DAY（A2） 进入空白单元格D2，然后按 输入 键。 然后将“填充手柄”向下拖动到该范围，以从引用的日期列表中提取所有日期。
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 26 days agothis website help me to find what ive been searching all this time.. many thanks..
To post as a guest, your comment is unpublished.· 1 years agoThis is stupid. Anyone who comes to this website wants the day of the month to populate into a cell! Anyone can plug in a random number into cell A2 and the click into cell B2 and insert the formula =A2. That's not what anyone is looking for that comes to this page. People want the cell to populate with the DAY OF THE MONTH!!!! This information and website is USELESS!!!
To post as a guest, your comment is unpublished.· 10 months agoYou wanted the actual day of the week or month?? Day of the week would be...
=TEXT(B2,"dddd") for full day
=TEXT(B704,"ddd") for 3 letter day like Mon, Tue, Wed etc
To post as a guest, your comment is unpublished.· 10 months agoDid you actually read the site? The formula =DAY(A2) would extract the day of the month from whatever date you had entered in cell A2. How is that not what you're asking for?
To post as a guest, your comment is unpublished.· 10 months agoNo, that would extract the day number, not the actual day. I believe frank means he wants to see MON, TUE, WED etc.
To post as a guest, your comment is unpublished.· 1 years ago=MONTH(A2) drops the leading zero for single digit months. Having that cell formatted as Text does not solve. How to keep the leading zero?
To post as a guest, your comment is unpublished.· 1 years ago=text(A2, "mmm") for month name in abbreviations
=text(A2, "mmmm") for full month name
To post as a guest, your comment is unpublished.· 26 days agoThank u Sonu, u answered my question as well..