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

English
,
#1

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

#2

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

#3

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

#4

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).

#5

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.

#6

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.