Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell / Date Formatting Question when result = -0- | Excel Discussion (Misc queries) | |||
Template Question | Excel Discussion (Misc queries) | |||
Excel template for the date of Easter | Excel Discussion (Misc queries) | |||
Another date function question | Excel Worksheet Functions | |||
Date Question | Excel Worksheet Functions |