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