Hi,
i am working on a script and looking for syntax which gives me the first date of the month in which i am running the macro.
means i will run the same macro every month in the first week. whenever i run the macro i need the first date of that month in the A2 cell.
if i am running the macro in september it should give me 09/01/2014
if i am running the macro in october it should give me 10/01/2014
can someone help me on this.
regards,
vimala k
Bookmarks