Excel: Finding nearest Friday formula


Hi, I have an IF formula that looks to a particular date and brings back the nextFriday however I need to change it so that if the date is already a Friday that is keeps this date rather than taking the following friday. The current formula I have is: =IFERROR(IF(WEEKDAY([@[EXPECTED PAYMENT DATE]]) < 6, [@[EXPECTED PAYMENT DATE]] + (6- WEEKDAY([@[EXPECTED PAYMENT DATE]])), [@[EXPECTED PAYMENT DATE]] + 13 - WEEKDAY([@[EXPECTED PAYMENT DATE]])),0) Thanks!


This question generated 47 answers. To proceed to the answers, click here.

This thread is current as of February 25, 2014.


For more resources for Microsoft Excel