Hi Matthew,

Am Mon, 17 Sep 2012 10:59:01 -0700 (PDT) schrieb Matthew Dyer:

With other's help, I was provided a function to assist in determining
the working mid-month day of the month (or the next month), but it
needs a little refining... Let me explain. We'll start with the
function:

=WORKDAY(DATE(YEAR(A1),MONTH(A1)+(DAY(A1)=15),16) ,-1)

If the date in cell a1 is 9/1/2012, then the function returns
9/14/2012, which is the last working day on or before the 15th of that
month. Put in 09/17/2012 and it returns 10/15/2012, which is correct.
But, if the date is 08/15/12 then the function returns 09/14/2012,
which is incorrect. It should still return 08/15/2012 since this is
the working day on or before the 15th. I can correct that by removing
the =, but then 09/15/2012 would return 09/14/2012 instead of
10/15/12. Can someone help me w/ this?

try:
=IF(WORKDAY(DATE(YEAR(A1),MONTH(A1),16),-1)<A1,WORKDAY(DATE(YEAR(A1),MONTH(A1)+1,16),-1),WORKDAY(DATE(YEAR(A1),MONTH(A1),16),-1))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2