arraysexceldateformuladatestamp

Need help adding date stamp to excel formula


I have created an array formula I would like to add a current date timestamp mm/dd/yy to the end of it instead of changing the date manually as shown in the formula below. Is there any way I can fit that in to this formula?

Thanks for any help with this.

Here is the formula

=J2&" "&L2&" "&O2&" "&N2&" "&"Per OM nlh 2/4/15"


Solution

  • Try changing your formula to this:

    =J2&" "&L2&" "&O2&" "&N2&" "&"Per OM nlh "&TEXT(TODAY(),"m/d/yy")