# need a little help

#### UPN

##### Board Regular
i found this formula to tell me what day Thanksgiving is depending on year

=DATE(Z8,11,1)+IF(5<WEEKDAY(DATE(Z8,11,1)),7-WEEKDAY(DATE(Z8,11,1))+5,5-WEEKDAY(DATE(Z8,11,1)))+((4-1)*7)

What i need is to modify it so i can find the Friday afer thanksgiving

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

#### UPN

##### Board Regular
sorry incomplete formula

=DATE(Z8,11,1)+IF(5greater than WEEKDAY(DATE(Z8,11,1)),7-WEEKDAY(DATE(Z8,11,1))+5,5-WEEKDAY(DATE(Z8,11,1)))+((4-1)*7)

#### NBVC

##### Well-known Member
You mean the day after?

Like this?

=DATE(Z8,11,1)+IF(WEEKDAY(DATE(Z8,11,1)),7-WEEKDAY(DATE(Z8,11,1))+5,5-WEEKDAY(DATE(Z8,11,1)))+((4-1)*7)+1

#### Peter_SSs

##### MrExcel MVP, Moderator
sorry incomplete formula

=DATE(Z8,11,1)+IF(5greater than WEEKDAY(DATE(Z8,11,1)),7-WEEKDAY(DATE(Z8,11,1))+5,5-WEEKDAY(DATE(Z8,11,1)))+((4-1)*7)
To avoid the incomplete formula problem, select the formula and click the 'Code' button above the window you are typing in. If you are using the 'Quick Reply' window then this button does not appear but you can type the word code enclosed in square brackets before your formula and type /code enclosed in square brackets after your formula. Your formula would then look like this
Code:
``=DATE(Z8,11,1)+IF(5>WEEKDAY(DATE(Z8,11,1)),7-WEEKDAY(DATE(Z8,11,1))+5,5-WEEKDAY(DATE(Z8,11,1)))+((4-1)*7)``

#### UPN

##### Board Regular

thanks

thanks about the code thing. i did not know about that

#### barry houdini

##### MrExcel MVP
=DATE(Z8,11,1)+IF(5greater than WEEKDAY(DATE(Z8,11,1)),7-WEEKDAY(DATE(Z8,11,1))+5,5-WEEKDAY(DATE(Z8,11,1)))+((4-1)*7)

This formula appears to give Thanksgiving as 30th November for this year. My understanding is that Thanksgiving is the 4th Thursday in November (in the US) which would make it 23rd November 2006.

To get the day after Thanksgiving when year is in Z8

=DATE(Z8,11,29)-WEEKDAY(DATE(Z8,12,1))+1

#### UPN

##### Board Regular
MY mistake in formula...should be less then

Replies
6
Views
221
Replies
6
Views
171
Replies
1
Views
92
Replies
10
Views
258
Replies
3
Views
203

1,141,589
Messages
5,707,267
Members
421,499
Latest member
Dpbj

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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