Writing Excel User Defined Functions in VBA – part #2 – time stamping, concatenating date and text while maintaining the date format

01/19/2011

Hi Folks, there are many available built-in spreadsheet functions in Excel. Ocasionaly one might need to write a special custom function. This second short tutorial is an introduction to that.  Creating a “Time Stamp” function is presented as a first example after which a concatenation function between a custom formatted date and a string (text) is introduced. This last function came about from a question I was asked by a finance person at…

Read More >>