compute upcoming Sunday date in a cell

[CJ]

Greetings,

In Excel, I am trying to create a formula for a cell that
will input the date of the upcoming Sunday, regardless of
what date on which you open the document. For example,
if I open the document on Wednesday, November 24, the
cell will display 11/28/2004 since the 28th is the next
Sunday following November 24th. I am familiar with the
=(TODAY) function but I am not sure how to add a
variable number of days to get the next Sunday.

Please help!
Thanks,
CJ

 

[Ron Rosenfeld]

Greetings,

In Excel, I am trying to create a formula for a cell that
will input the date of the upcoming Sunday, regardless of
what date on which you open the document. For example,
if I open the document on Wednesday, November 24, the
cell will display 11/28/2004 since the 28th is the next
Sunday following November 24th. I am familiar with the
=(TODAY) function but I am not sure how to add a
variable number of days to get the next Sunday.

Please help!
Thanks,
CJ

The formula:

=A1-WEEKDAY(A1)+8

will always give the next Sunday after the date in A1.

You may substitute TODAY() for A1 in the above formula.


--ron

 

[CJ]

Ron,
Thank you - much appreciated.
CJ

-----Original Message-----


The formula:

=A1-WEEKDAY(A1)+8

will always give the next Sunday after the date in A1.

You may substitute TODAY() for A1 in the above formula.


--ron
.