On Mon, 14 Nov 2005 09:52:36 -0600, tkaplan
wrote:


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


My misreading. Try:

B1: =A1-DAY(A1)

C1: =B1-DAY(B1)+1-WEEKDAY(B1-DAY(B1)+2)


--ron