by
12k 31

Get Current Date In VBA

How to use date function for getting date in VBA Excel. In VBA you can't use today() function but you can use date ()
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/13208/Get-Current-Date-In-VBA?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
' In VBA you can't use today() function ' instead you have to use date () 'get today date: Cells (1,1) = Date 'get yesterday date: Cells (1,1) = Date - 1
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus