Formula for date Closed

Question

Hello, 

I am doing a macro in which while doing page setup we have to put that days date in header, Is there any formula we could give so that it automatically takes the present date while running the macro into the header.

Regads,
Sindesh

Configuration: Windows XP / Firefox 3.6.8

venkat1926 · Answer

not clear.
in excel vba  DATE is used for entering today's date. But this is a volatile function and the entry may change tomorrow. so you want to fixed after entering date
copy and pastespecial on the same cell values only so that it will not change tomorrow.

Ray · Answer

' Choose where you want the date to go in the header.
With ActiveSheet.PageSetup
        .LeftHeader = Date
        .CenterHeader = Date
       .RightHeader = Date
    End With

This will populate the page header with the current date each time it is run.

Formula for date

2 responses

Similar discussions

Subscribe To Our Newsletter!