No daddy. What I'm now re-doing is a time sheet. On the 1st day of July
each year, 3 personal leave days are add for us to use whenever. I need to
add it on that date, and for it to remain visible thru the end of the pay
period, so the total can carry forward.....Thanks....Ben

"daddylonglegs" wrote:


Do you mean you want to know whether 1st July is a Monday, Tuesday
etc.?

you could use this formula

=TEXT(DATE(2006,7,1),"dddd")

or just put the date in a cell and format that cell as dddd


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=523259