• Home
  • VBA Tutorial
  • VBA Cheat Sheet
  • VBA Time Saver
  • Excel SQL Add-In
  • VBA Web Scraping Kit
  • LOOKUP AddIn
  • Merch

Analyst Cave

Simply the best place to learn Excel and Analytics

  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video
  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video

Home » VBA Function – Reference of VBA Functions » VBA Date Functions

VBA Date Functions

Below listed are VBA functions supporting Date and Time:

VBA Date
VBA DateAdd
VBA DateDiff
VBA DatePart
VBA DateSerial
VBA DateValue
VBA Day
VBA Hour
VBA Minute
VBA Month
VBA MonthName
VBA Now
VBA Second
VBA Time
VBA Timer
VBA TimeSerial
VBA TimeValue
VBA Weekday
VBA WeekdayName
VBA Year
VBA Date Functions

Download VBA Time Saver

VBA Time Saver Kit

Ready VBA Code snippets for Arrays, Strings, File Dialogs, Read/Write Files, Timers, Progress Bar

Download LOOKUP Wizard

Excel Lookup Wizard Book1

Lookup data from external Excel files and worksheets with the Excel LOOKUP Wizard AddIn!

Articles