I am trying to figure out how to compute the following:

user enters in a date in A1.
B1 needs to calculate the month prior.
C1 needs to calculate the last friday of the month prior to B1.

so if A1 is 11/14/2005,
B1 should be October 2005
C1 should be 9/30/2005

I know how to do B1. I am having a hard time with C1.

Thanks in advance


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