The date last Friday

Occasionally you may want to know what the date was last Friday, or any day last week for that matter.

This example, used in any cell will give the exact date that last Friday was. It can be adapted to identify the date for any given day the previous week.

=TODAY()-WEEKDAY(TODAY())-1






Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us
the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group