Forum Discussion
Automatic Date Change
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
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)
2 Replies
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)
- Thanks flexyourdata. It looks like that did the trick.
