Adding a Automatic week ending date

[miguel2435]

I want to add a week ending date that automatically populates the cell.

 

[Akashwani]

Hi,

I think that you need to provide some more information.
Where do you want the week ending date?
What will this date be based on?

Excel Workbook
	A	B	C	D	E
1	Date	Weekending	*	Today	Weekending
2	03/01/2011	09/01/2011	*	08/06/2011	12/06/2011
3	03/02/2011	06/02/2011	*	*	*
4	03/03/2011	06/03/2011	*	*	*
5	03/04/2011	03/04/2011	*	*	*
6	03/05/2011	08/05/2011	*	*	*
7	03/06/2011	05/06/2011	*	*	*
8	03/07/2011	03/07/2011	*	*	*
9	03/08/2011	07/08/2011	*	*	*
10	03/09/2011	04/09/2011	*	*	*
11	03/10/2011	09/10/2011	*	*	*
12	03/11/2011	06/11/2011	*	*	*
13	03/12/2011	04/12/2011	*	*	*
Sheet1

Ak

 

[miguel2435]

I just want the week ending date to show every Sunday. When Monday starts the new week I want to show the following Sunday's date as the week ending date. For example, say I am using cell B:3 as the week ending date. Each Monday I want that cell to auto populate the next week ending date which would be the next Sunday.

I hope this helps.

Thanks.
Mike

 

[Akashwani]

Hi Mike,

Does this work in B3?....

=IF(WEEKDAY(TODAY())=1,TODAY(),TODAY()-WEEKDAY(TODAY())+8)


Ak

 

[miguel2435]

Absolutely, I appreciate your help.

Thank you very much.