Hi all,
I am trying to get this formula to work and have tried it a variety of ways and I just can't figure out what I am doing wrong....The end result should be:
Pay Period 1
January 1, 2012 to January 10, 2012
I have this:
=C2& " "TEXT(D2,mmmm/dd/yyyy)& " "(E2) " "TEXT(D11,mmmm/dd/yyyy)
Workbook attached for cell reference. Also, I do not know how to indicate [ENTER], as in to go to the next line in a formula. Any help would be greatly appreciated - thanks
Bookmarks