I am using Excel 2016 and when using the formula "=WORKDAY(A2,1,$D$2:$D$14)" to list all workdays in year for date specified in cell A2. When I drag fill the formula past the last workday of the year in A2 in goes into the next year. Is there a way to drag fill the formula down past the last day of year in A2 and it not display the next year instead the cell will be blank? Thanks for your help, Frankie
Bookmarks