working on it ...

Filters

Explore Public Snippets

Sort by

Found 1 snippet matching: "get current date excel vba"

    public by fabio.nosenzo  6544  1  7  1

    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 ()
    ' 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

    List Complete ( 1 snippet total )

    Cannot find what you were looking for?
    Ask the Snip2Code Community

    • Public Snippets
    • Channels Snippets