| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date to update after 7 days Please
Hello from Steved
In Cell B3 I would like to put a formula that updates every Sunday to that date off that day. How would one go about this please. Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date to update after 7 days Please
Use this formula =TODAY()-WEEKDAY(TODAY())+1 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511997 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date to update after 7 days Please
Exactly what I required and I thank you both.
Cheers. "daddylonglegs" wrote: Use this formula =TODAY()-WEEKDAY(TODAY())+1 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511997 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date to update after 7 days Please
Thankyou
"daddylonglegs" wrote: Use this formula =TODAY()-WEEKDAY(TODAY())+1 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511997 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date to update after 7 days Please
If I understand you correctly, you basically want a formula that will show
the date of the most recent Sunday? If so, this should work for you: =TODAY()-WEEKDAY(TODAY())+1 HTH, Elkar "Steved" wrote: Hello from Steved In Cell B3 I would like to put a formula that updates every Sunday to that date off that day. How would one go about this please. Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| date (minus) date = working days diff | Excel Discussion (Misc queries) | |||
| Number of days since a date | New Users to Excel | |||
| set a date in columns 7 days apart | Excel Worksheet Functions | |||
| Automatic Date Update | Excel Discussion (Misc queries) | |||
Hybrid Mode
