Hi Steve,

I did copy and paste this part. It shows up as:

=IF(A6="","",IF(DAY(WORKDAY(A6,1))31,"",IF(MONTH(
WORKDAY(A6,1))MONTH($A$1),"",IF(YEAR(WORKDAY(A6,1
))YEAR($A$1),"",WORKDAY(A6,1)))))

Perhaps there is a missing piece.

Monique



"daddylonglegs" wrote:


SteveG Wrote:
Slight typo. You need to change the A1 in the YEAR formula to an
absolute reference.

=IF(A6="","",IF(DAY(WORKDAY(A6,1))31,"",IF(MONTH(
WORKDAY(A6,1))MONTH($A$1),"",IF(YEAR(WORKDAY(A6,1
))YEAR($A$1),"",WORKDAY(A6,1)))))

Hi Steve/Monique

checking IF(DAY(WORKDAY(A6,1))31 is redundant since it can never be
true. Won't this formula in B6 copied across be sufficient?

=IF(A6="","",IF(MONTH(WORKDAY(A6,1))<MONTH(A6),"" ,WORKDAY(A6,1)))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537695