Formula not populating certain rows

John Teh

Hi everyone,

I'm seeing an issue where I have a particular formula that moves a date to the nearest business day if the original date lands on a weekend. However, when I drag the formula down the column, it will not populate certain cells. (This is actually apparent across the entire row). Would you know how to solve this?

David Tutwiler

I think the problem is that your IF statement only accounts for dates that fall outside of weekdays. You're only solving the TRUE side of the equation, if that makes sense. So what's happening is the formula is putting data in for all of the instances where the date needs to be adjusted, but doesn't know what to do if the date is a Weekday.

To fix this, I think you just need to move your next to last closed parentheses to right after the Holiday Range. The Workday only takes 3 parameters, so you should close it there and allow the last October Grant Date to be what you feed the false parameter of your IF statement.

Does that make sense?

David Tutwiler

I think the problem is that your IF statement only accounts for dates that fall outside of weekdays. You're only solving the TRUE side of the equation, if that makes sense. So what's happening is the formula is putting data in for all of the instances where the date needs to be adjusted, but doesn't know what to do if the date is a Weekday.

To fix this, I think you just need to move your next to last closed parentheses to right after the Holiday Range. The Workday only takes 3 parameters, so you should close it there and allow the last October Grant Date to be what you feed the false parameter of your IF statement.

Does that make sense?

John Teh

This worked! Thank you, David.

David Tutwiler

Awesome!