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

[@excelisfun]

Thanks for all your videos!!

[@ExcelVbaIsFun]

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]

no equation. Check out my video on loops by searching on my channel. But when you create a 'FOR/NEXT' loop, you say For X = (starting number) to (ending number) 'put your code here that involves the escalating variable, in this case x then add Next x at the bottom. Everything in between the FOR part at the top and the NEXT part at the bottom happens over and over again until x has exceeded the ending number.

[@ESongslk]

Super Super Super Super 😘😘😘😘👍👍👍👍 Only you tell me how to add dates Found exactly thank you

[@iAhmad_Q]

One question: I have different frequency types (e.g: semi-annual, every 3 months). Is there any work around to use these frequencies with the DateAdd function?

[@danjtitchener]

How was the meaning of the word "Quarter" captured by the table of text? Are the values in the explanation column actual values in VBA? (like "true" for example?) Thanks for the great vids!

[@miguelangelvalladaressanta8715]

Good night in cycle in vba for next I want in a loan system to bring me the installments daily modality, example 20 installments that start on 01-10-22 and I want 20 installments but exclude Sundays and the 20 installments are fulfilled, what would be the code

[@iAhmad_Q]

Powerful function. Thanks!

[@talk2stop]

This is magic. What I am looking for. Thanks

[@ExcelVbaIsFun]

Yen-Moy Yap I'm so glad it helped! Thanks for letting me know. Dan

[@MohammadTaha]

to put stDate to equal a date value you put tow # around the date expression: Example: stDate = #12/31/2005# good luck

[@ExcelVbaIsFun]

Awesome, great tip Mohammad!

[@MohammadTaha]

:)

[@jessli7257]

Hi Dan, Working with Dates gives an error on my vba macbook. How do i get my vba to recognise the dates?

[@darwinchan5573]

i try to make a comment before Debug.Print stdate, however, there is no response from immediate window, why is it? So next time to make immediate window works, i need to include Debug.Print in my code?