Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Winston
 
Posts: n/a
Default Friday In Month


Hi All

I know I am A pest but can anyone help with my next problem as below?

If this friday's day is equal or less than any day in any month then
friday equals amount.

Hope you understand my problem

Regards

Winston.




--
Winston
------------------------------------------------------------------------
Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344
View this thread: http://www.excelforum.com/showthread...hreadid=479621

  #2   Report Post  
Roger Govier
 
Posts: n/a
Default Friday In Month

Hi Winston

You need to give a little more explanation.
How can it be equal or less than any day in any month?
What equals Friday's amount?


Regards

Roger Govier


Winston wrote:
Hi All

I know I am A pest but can anyone help with my next problem as below?

If this friday's day is equal or less than any day in any month then
friday equals amount.

Hope you understand my problem

Regards

Winston.




  #3   Report Post  
Winston
 
Posts: n/a
Default Friday In Month


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

  #4   Report Post  
David McRitchie
 
Posts: n/a
Default Friday In Month

Hi Winston,
Your question is not clear, check out a few web pages to see
if the answer to your question can be found there, or to at least
get a handle on the question you want to ask.

http://www.mvps.org/dmcritchie/excel....htm#firstdate
http://www.mvps.org/dmcritchie/excel/datecalc.htm
http://www.cpearson.com/excel/datetime.htm
http://www.cpearson.com/excel/DateTimeVBA.htm#NDow
---
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

I know I am A pest but can anyone help with my next problem as below?

If this friday's day is equal or less than any day in any month then
friday equals amount.

Hope you understand my problem

Regards

Winston.




--
Winston
------------------------------------------------------------------------
Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344
View this thread: http://www.excelforum.com/showthread...hreadid=479621



  #5   Report Post  
David McRitchie
 
Posts: n/a
Default Friday In Month

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find out first Friday every month Ragdyer Excel Discussion (Misc queries) 7 September 2nd 05 12:59 AM
Find out first Friday every month noiseash Excel Worksheet Functions 3 September 1st 05 09:24 AM
3rd friday in month [email protected] Excel Worksheet Functions 17 June 11th 05 08:47 PM
Date Calculations Bruce Excel Worksheet Functions 11 May 19th 05 01:09 AM
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 07:43 PM


All times are GMT +1. The time now is 09:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"