VBA to Enter String (Constant) and Last Day of Previous Month

[Hollando]

Hello all,

Trying to figure out how I can wing this last thing for a tool I'm building.

Basically in cell A1 I need to enter this string "'Gadgets Sales ending' September 30 2013" (September 30 2013 being the variable).

Any thoughts on how I can accomplish this would be greatly appreciated.

Regards,

Hollando

 

[Rick Rothstein]

Does this do what you want?

="'Gadgets Sales ending' "&TEXT(TODAY()-DAY(TODAY()),"mmmm d yyyy")

If you did not really mean "previous month to today", then just substitute a cell containing a date for both of the TODAY() functions.

 

[Hollando]

Does this do what you want?

="'Gadgets Sales ending' "&TEXT(TODAY()-DAY(TODAY()),"mmmm d yyyy")

If you did not really mean "previous month to today", then just substitute a cell containing a date for both of the TODAY() functions.

Thanks for the quick response Rick. This worked great!