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