# "end of week"

#### patel20626

##### New Member
I'm wondering if there's a way to set a formula that updates to the upcoming Friday based on the current date. For example, if the current date is Thursday, March 5, 2009, this formula would return an answer of Friday, March 6, 2009. Once the date becomes Saturday, March 7, 2009, this formula would then return an answer of Friday, March 13, 2009. Is this possible?

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Hello patel20626, welcome to MrExcel

If you have todays' date in A1 then this formula will give you the upcoming Friday

=A1+7-WEEKDAY(A1+1)

If you want you can replace A1 with TODAY(), i.e.

=TODAY()+7-WEEKDAY(TODAY()+1)

Thank you very much barry houdini. That formula is exactly what I needed!

Replies
4
Views
248
Replies
2
Views
215
Replies
1
Views
145
Replies
4
Views
124
Replies
1
Views
131

1,196,127
Messages
6,013,611
Members
441,777
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back