Hello all. I am still trying to get this timesheet where I want it.

This is where I am at:

I have a cell that mentions the year (G7) and the sheet mentions the
pay period beginning (ex: January 1).

I would like to have a different cell (B9) combine the two into a date
that other cells would recognize as such.

For instance, if the sheet name is January 1st and cell G7 has "2006"
as a value, then I would like B9 to read "1/16" (year not shown). From
there another cell (A13) would show that day/date as "Sunday, January
01, 2006".

Any help would be greatly appreciated.


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=555570