Excel VBA or Formula how to set cell to first day of the month

[robrobet]

I want to select one cell in my worksheet to have a date of 1st of the month. when I open worksheet no matter which day of the month Or Which month that cell show the date of the 1st day of the current month.

Thanks

[MaczaQ]

try this UDF function

Please Login or Register  to view this content.

paste above code into standard module and refer to it in cell You need to i.e. A1 formula = ThisMonthFirstDay()

[robrobet]

Sorry, did not work for me may be I am doing something wrong here, I have few sheet in my workbook, how I am able to set this to sheet1, cell a5 ?

Please explane,

Thanks
RR

[MaczaQ]

this is global function You have to copy my code into Module and then in Sheet1 in cell a5 set formula "=ThisMonthFirstDay()"

[robrobet]

Thanks a lot it work now,

[MaczaQ]

Your Welcome !

[robrobet]

When I open workbook today it did not change to June 1st, It work last time when I set it in may.