This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Assuming a week begins on a Friday and ends on a Thursday, I need to find the previous Friday's date based on the current date. For example, if the current date is 1/3/2013, then the previous Friday's date would be 12/28/2012. However, if the current date is 1/4/2013, then the previous (although technicaly not "previous") Friday's date would be 1/4/2013.
Using the rule and examples above, can someone kindly tell me how to write a formula that will calculate the previous Friday's date based on the current date? Thanks in advance for any assistance.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Or, again with a date in D1:
=D1+1-WEEKDAY(D1,15)
This works in Excel 2010 and later only.
Answer accepted by question author
Try
=D1-CHOOSE(WEEKDAY(D1,1),2,3,4,5,6,0,1)
where D1 is the date in question.
Like this:
Date()+1-Weekday(Date(),6)
Added later: oops, my reply is for VBA (and Access), not a worksheet formula.
Thanks for your very concise solution. I appreciate your help (as always).
Thanks for your help! I completely forgot about the WEEKDAY function.