How can I create a formula that calculates the week ending date (date every Friday) so that it automatically appears according to the current date
For example the week ending date of this weeks pay period is 01-30-03 but if I open the spreadsheet on Monday 01-26, how do I get the week ending date to populate