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.
i currently have:
TEXT((6-WEEKDAY(EOMONTH(A1,-2)-7))+(EOMONTH(A1,-2)-7),"m/d/yyyy")
This works as long as that last friday is not the last day of the month - which is not good enough. I am sure there is also a better and easier way to do it than the way i did it above. So any assistance would be appreciated.
Thanks in advance
Bookmarks