How to return a range of dates between two cell values (workday only)?

[AccountingJ]

Hello - I have the workbook attached where I want the workdays returned if they fall between cell values B3 and F3 but also need to exclude the dates in column J.

I know I need to use the workday function but get #value! error when I try and use it (see cell h7). Any ideas why?

Also, cell D7 and F7 are not returning the next date like it's supposed to and I don't get why.

[Metoo7]

try this:

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[AliGW]

Try this one in H7 copied down:

=WORKDAY.INTL(IF(H6="",$B$3-1,H6),1,1,$J$5:$J$7)

Are you still using Excel 2010?

[AccountingJ]

First, thank you all for your time/help.

AliGW - No, let me update that section of my profile.

Thanks again everyone

[Fluff13]

Glad to help & thanks for the feedback

[AliGW]

Your profile still says MS 2010!!!

Was my suggestion of any use? It's nice to know what has worked/not worked. etc.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.