Automatic Date Change

[John_Dz]

Hello all,

To start off, my Excel skills are pretty basic. I want to have a cell on my worksheet that displays the date for Friday of the current week. Then on the following Monday, the date in that cell needs to change to the date for the Friday of that week. Any assistance is greatly appreciated.

Thanks,

John

[#2 · Accepted solution]

@John_Dz 

This will give the date of the Friday of the same week as the date in cell A1:

=A1-WEEKDAY(A1)+6

This will give the date of the Friday of the same week as today:

=TODAY()-WEEKDAY(TODAY())+6

If you have Office 365, then this is a bit neater:

=LET(d,TODAY(),d-WEEKDAY(d)-6)

[#3]

Thanks @flexyourdata. It looks like that did the trick.