Previous Friday
=B1-CHOOSE(WEEKDAY(B1,1),2,3,4,5,6,7,1)
Last Friday of Month
=DATE(YEAR(B1),MONTH(B1)+1,0)-CHOOSE(WEEKDAY(DATE(YEAR(B1),MONTH(B1)+1,0),1),2,3 ,4,5,6,0,1)
or Friday previous to last day of month
=DATE(YEAR(B1),MONTH(B1)+1,0)-CHOOSE(WEEKDAY(DATE(YEAR(B1),MONTH(B1)+1,0),1),2,3 ,4,5,6,7,1)
2005-10-27 Thu 2005-10-21 Fri 2005-10-28 Fri 2005-10-28
2005-10-28 Fri 2005-10-21 Fri 2005-10-28 Fri 2005-10-28
2005-10-29 Sat 2005-10-28 Fri 2005-10-28 Fri 2005-10-28
2005-10-30 Sun 2005-10-28 Fri 2005-10-28 Fri 2005-10-28
2005-10-31 Mon 2005-10-28 Fri 2005-10-28 Fri 2005-10-28
2005-11-01 Tue 2005-10-28 Fri 2005-11-25 Fri 2005-11-25
2005-11-02 Wed 2005-10-28 Fri 2005-11-25 Fri 2005-11-25
2005-11-03 Thu 2005-10-28 Fri 2005-11-25 Fri 2005-11-25
2005-11-04 Fri 2005-10-28 Fri 2005-11-25 Fri 2005-11-25
2005-11-05 Sat 2005-11-04 Fri 2005-11-25 Fri 2005-11-25
2005-11-06 Sun 2005-11-04 Fri 2005-11-25 Fri 2005-11-25
2005-11-07 Mon 2005-11-04 Fri 2005-11-25 Fri 2005-11-25
2005-11-08 Tue 2005-11-04 Fri 2005-11-25 Fri 2005-11-25
2005-11-09 Wed 2005-11-04 Fri 2005-11-25 Fri 2005-11-25
2005-11-10 Thu 2005-11-04 Fri 2005-11-25 Fri 2005-11-25
2005-11-11 Fri 2005-11-04 Fri 2005-11-25 Fri 2005-11-25
2005-11-12 Sat 2005-11-11 Fri 2005-11-25 Fri 2005-11-25
2005-11-13 Sun 2005-11-11 Fri 2005-11-25 Fri 2005-11-25
2004-04-30 Fri 2004-04-23 Fri 2004-04-30 Fri 2004-04-23
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Winston" wrote in message
...
Hi All
Ok I will try to explain
The spreadsheet I am trying to do seems to be more difficult than I
anticipated.
I have a spreadsheet that forecast's the next 6 months ahead that I
have to update manually, I would like to automate it.
I have Credits and Debits dates as follows
Weekly
Monthly
Last Working Day In Month
Every 4 weeks.
I need to find out how to calculate the above date types 
I need to calculate from the above information the last Friday that I
need to allow funds for these Debits.
Example Of Debit
Date =15th
Current Month=November
So I need to allow enough funds are in account for friday 11th.
Example Of Credits
Credits are just on dates so I should be able to use answer from date
types as above.
Where do I start
Any help would be appreciated
Winston
--
Winston
------------------------------------------------------------------------
Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344
View this thread: http://www.excelforum.com/showthread...hreadid=479621