ExcelBanter - Template / date question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Template / date question (https://www.excelbanter.com/excel-worksheet-functions/6522-template-date-question.html)

macamarr

Template / date question

In my Worksheet I use a cell for the week of. What I would am attempting to
do is have the cell show the Sunday date of the week that we are in. Example:
Today is 11/16/04 so the week of date should be 11/14/04. The following week
when the template is opened should show 11/21/04.

Frank Kabel

Hi
try
=TODAY()-WEEKDAY(TODAY())+1
and format this as date

"macamarr" wrote:

In my Worksheet I use a cell for the week of. What I would am attempting to
do is have the cell show the Sunday date of the week that we are in. Example:
Today is 11/16/04 so the week of date should be 11/14/04. The following week
when the template is opened should show 11/21/04.

All times are GMT +1. The time now is 11:42 PM.