| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Update on New Page
I would like to enter a date (not today's date) on Worksheet 1 and then
update it automatically on Worksheet 2. Worksheet 1: January 1, 2009 Worksheet 2: January 2, 2009 What formula would accomplish this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Update on New Page
NichGrif wrote:
I would like to enter a date (not today's date) on Worksheet 1 and then update it automatically on Worksheet 2. Worksheet 1: January 1, 2009 Worksheet 2: January 2, 2009 What formula would accomplish this? On Worksheet 2: =1+'Worksheet 1'!A1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Update on New Page
and format the formula cell to excel date format///
If this post helps click Yes --------------- Jacob Skaria "smartin" wrote: NichGrif wrote: I would like to enter a date (not today's date) on Worksheet 1 and then update it automatically on Worksheet 2. Worksheet 1: January 1, 2009 Worksheet 2: January 2, 2009 What formula would accomplish this? On Worksheet 2: =1+'Worksheet 1'!A1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Update on New Page
Thank you!
What if I want to update a day of the week? Worksheet 1: Sunday Worksheet 2: Monday "smartin" wrote: NichGrif wrote: I would like to enter a date (not today's date) on Worksheet 1 and then update it automatically on Worksheet 2. Worksheet 1: January 1, 2009 Worksheet 2: January 2, 2009 What formula would accomplish this? On Worksheet 2: =1+'Worksheet 1'!A1 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Update on New Page
I recommend you use the same formula I gave earlier with a proper date
in A1. Format A1 to display as day-of-week using custom format dddd. Or, if you want to use text values try this: =INDEX({"Sunday","Monday","Tuesday","Wednesday","T hursday","Friday","Saturday"},1,MATCH('Worksheet 1'!A1,{"Saturday","Sunday","Monday","Tuesday","Wed nesday","Thursday","Friday"},0)) NichGrif wrote: Thank you! What if I want to update a day of the week? Worksheet 1: Sunday Worksheet 2: Monday "smartin" wrote: NichGrif wrote: I would like to enter a date (not today's date) on Worksheet 1 and then update it automatically on Worksheet 2. Worksheet 1: January 1, 2009 Worksheet 2: January 2, 2009 What formula would accomplish this? On Worksheet 2: =1+'Worksheet 1'!A1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| How can we automatically update page numbers for inserted tab? | Excel Discussion (Misc queries) | |||
| input a date or update it based on date in another cell | New Users to Excel | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
| update graph web page | Charts and Charting in Excel | |||
Linear Mode
