Excel VBA Basics #26 WeekdayName and MonthName in VBA

preview_player
Показать описание

Easily get the short name or full name of the weekday or the month. Examples are

answer=WeekdayName("1/1/2013")
the value for answer would be "Tuesday"

answer=MonthName("2/14/2016")
where answer would be "February"

Fantastic Developer Tools:
  1. ExcelVbaIsFun
  2. Microsoft Excel (Software)
  3. macro
  4. VBA
  5. Visual Basic
  6. reports
Рекомендации по теме
Excel VBA Basics 0:04:24

Excel VBA Basics #26 WeekdayName and MonthName in VBA

Excel VBA Basics 0:08:03

Excel VBA Basics #25 Extract the DAY, WEEKDAY, MONTH, YEAR from a date. How to use DateSerial

Excel VBA Basics 0:07:28

Excel VBA Basics #16A ERRORS - Custom Code On Error, Using GOTO Labels

Excel VBA Basics 0:10:59

Excel VBA Basics #23 DATEADD - Add or Subtract Minutes, Months, Weekdays, Seconds whatever!!

VBA Day of 0:02:19

VBA Day of the week

Textbox Find Day 0:08:36

Textbox Find Day And Weekday And weekNum Excel VBA

Date Functions || 0:02:55

Date Functions || MonthName Function In VBA Macros || VBA Basics || MonthName with Abbrevation

Excel VBA Basics 0:17:17

Excel VBA Basics #27 Borders - Shading, Color and Placement in VBA

Identify weekdays with 0:01:06

Identify weekdays with the WEEKDAY function

Worksheet Fill Date 0:11:15

Worksheet Fill Date And Day And Weeknum Excel VBA

Excel VBA Basics 0:08:52

Excel VBA Basics #24 DateDiff in VBA - Difference in Seconds, Hours, Weekdays, Quarters, Months, Etc

WeekdayName Function 0:01:00

WeekdayName Function

Excel VBA Basics 0:12:45

Excel VBA Basics #5 - Toolbars, Messageboxes, Object Browser, Autocomplete and Code Windows

Excel VBA Basics 0:06:57

Excel VBA Basics #21 Put VLOOKUP info in StatusBar using Application.Statusbar

UDF 3 MonthName 0:09:51

UDF 3 MonthName and Weekday name

Date Functions || 0:05:06

Date Functions || Retrieve Max Day Of Month Using Day And DateSerial Functions || VBA Basics

How To Extract 0:05:23

How To Extract Year Month Day from Date in Excel VBA

Excel VBA Worksheet 0:08:14

Excel VBA Worksheet Basics

Convert date to 0:02:36

Convert date to week number of the year in Excel using VBA

3 40 Functions 0:04:02

3 40 Functions Date Weekday Weekdayname

VBA Month Name 0:00:56

VBA Month Name to Number in Excel

ba003 VBA работа 0:15:58

ba003 VBA работа с датами

Learn Excel - 0:15:53

Learn Excel - Video 279- VBA Functions Month FileDateTime MonthName

Date Functions in 0:02:37

Date Functions in VBA || DateSerial Function || VBA Macros || VBA Basics

Комментарии
Автор

I love that the mastah, mr excel came by and posted! I love his channel, and this is an excellent compliment to his legacy. Keep up the fantastic work Dan, I am a fan bro!

jetpaq
Автор

Charlotte, you can get the last 2 digits of a year using Format(). so If you made a variable take on the last two it may look something like this.


last2=Format(myDate, "yy")

Dan

ExcelVbaIsFun
Автор

You're very welcome, johnyraku! Thanks!

ExcelVbaIsFun
Автор

Thank you so much Dan for all your tutorial videos!!! Really really great and helpful!
May I ask how I can extract the last two digits of a year? Or is there an easy way to convert the vbdate to dd-mmm-yy format? (I use this format because I couldn't name the worksheets as dd/mm/yy :( I am using your date picker to decide which worksheet to open.
Thank you!!!

DrCharTang
Автор

it's been great help but i don't get any values using square bracket [] i.e. [a1]. Could you tell me why is that.

lekshey