Let's say I need to find out my next payday. I get paid on the 19th of each month. My first payday is 1/19/2009. Today is 9/16/2009. The formula should result in 9/18/2009, because I have already been paid on 8/19, and because the 19th of September is a Saturday.