Ask Your Question
0

I want to enter the Sunday which comes after November 26th every year. What formula I have to use to get this?

asked 2017-12-26 14:40:31 +0200

snapakyohan gravatar image

Every year I want to get the Sunday which occurs after November 26th. If there any formula to get this, please share it.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-12-26 14:48:43 +0200

updated 2017-12-26 15:38:39 +0200

=DATE(A1;11;27)+6-WEEKDAY(DATE(A1;11;27);3)

edit flag offensive delete link more

Comments

Thank you very much. Its great. So I should enter the year in the A1 cell. Everything works perfectly fine. Thanks a ton.

snapakyohan gravatar imagesnapakyohan ( 2017-12-26 15:23:38 +0200 )edit

Slightly edited to make it obvious that it gets a date strictly after November 26th (i.e., if this date is Sunday itself, the result is the next Sunday).

Mike Kaganski gravatar imageMike Kaganski ( 2017-12-26 15:39:55 +0200 )edit

Wondering how quickly you made the formula. Based on your formula, I tried to find out the first Sunday in December =DATE(B1,12,0)+1+6-WEEKDAY(DATE(B1,12,0)+1,3) and that too worked fine. Thanks again for the instant help.

snapakyohan gravatar imagesnapakyohan ( 2017-12-26 16:56:26 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-26 14:40:31 +0200

Seen: 29 times

Last updated: Dec 26 '17