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?

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

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

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

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