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

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

Find the difference between two dates/times. Find out how many hours, seconds, quarters, months, years, weekdays, weeks, days, whatever!! You can calculate using similar descriptions as with DateAdd:

s Seconds
n Minutes
h Hours
d Days
w Weekdays
ww Weeks
m Months
q Quarters
y Days of the year
yyyy Years

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

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

Using Datediff Function 0:03:43

Using Datediff Function in VBA

Datediff in VBA 0:08:43

Datediff in VBA - Calculate difference in years, months and days etc.

Excel VBA - 0:03:38

Excel VBA - Dates

9. Excel VBA 0:10:29

9. Excel VBA - How we use Date and Time ?

Learn Excel - 0:21:41

Learn Excel - Video 231 - VBA Date Functions- DateDiff,Dateadd and Datepart,Format

VBA Number of 0:01:39

VBA Number of days between dates

DateDiff Function in 0:02:52

DateDiff Function in VBA | Excel VBA Tutorial in Hindi

DateDiff Function in 0:15:10

DateDiff Function in VBA | Excel VBA Tutorial in Hindi | VBA

EXCEL VBA - 0:08:34

EXCEL VBA - Complex Timesheet EP 09 - Breaking DateDiff PT 01

How to use 0:05:36

How to use datediff function with user form

EXCEL VBA - 0:20:20

EXCEL VBA - Complex Timesheet Ep. 10 - Breaking DateDiff PT 02 Enter the Array

Excel VBA Basics 0:04:24

Excel VBA Basics #26 WeekdayName and MonthName in VBA

Excel VBA Functions 0:09:34

Excel VBA Functions | Datediff in excel VBA | Excel VBA for beginners - 38

79 Other Useful 0:09:45

79 Other Useful Worksheet Triggers || VBA Tutorial || Lecture || Microsoft Excel ||

Excel VBA Basics 0:10:59

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

Excel VBA Basics 0:08:03

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

Date Functions in 0:02:37

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

How To Master 0:28:23

How To Master Working With Dates In VBA + Free Cheat Sheet

83 Datediff en 0:02:45

83 Datediff en VBA

Excel VBA Basics 0:01:04

Excel VBA Basics #21a Restore StatusBar to Normal - Simple!

3 Super Useful 0:05:08

3 Super Useful Date Functions in VBA

How to identify 0:01:00

How to identify or highlight expired or upcoming dates in Excel? - Excel Tips and Tricks

Visual Basic Tutorial 0:01:54

Visual Basic Tutorial - DateDiff Function

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

Perfect for my payroll requests application. Will completely change my functions...
Thanks dude!!!

TonyDiaz.
Автор

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

ExcelVbaIsFun
Автор

how do you use datediff that shows the elapsed minutes with 2 decimals?

FRAN-vdrl
Автор

Could you tell me how to show the answers in the cell of the Excel sheet?

髙橋孝義
Автор

how we can do datedif not datediff
coz i wana the day in range 365

mohamadhabibhomeidi
Автор

My excel on this code returns 15-4-1900.

Any idea?

Dim roznica As Integer
Dim obecna As Date, dzisiaj As Date
obecna = [h8]
dzisiaj = [l1]

roznica = DateDiff("d", obecna, dzisiaj)

BLNSKY
Автор

I'm trying to get this to work in a userform. Date is entered into txt_DOS. want txt_countweeks to be the number of weeks since the txt_dos.
private sub txt_dos_afterUpdate()
Dim dbsht As Worksheet
Set dbsht =
date1=dbsht.txt_dos.text
date2=Now()
dbsht.txt_countweeks= DIffDate("w", date1, date2)
end sub;

Any help from anyone in the community here is much appreciated. I'm banging my head on the keyboard right now.

mellowkoopa