i need the last friday of the month prior to the month in b1.

september 30 was a friday. if a1 is 11/14/05, i need b1 to say October
2005, and c1 to say 9/30/2005.
b1 i know how to do, i am having a problem with C1.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=484884