Date Update on New Page

[NichGrif]

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?

 

[smartin]

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

 

[Jacob Skaria]

and format the formula cell to excel date format///

If this post helps click Yes

 

[NichGrif]

Thank you!

What if I want to update a day of the week?

Worksheet 1:
Sunday

Worksheet 2:
Monday

 

[smartin]

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","Thursday","Friday","Saturday"},1,MATCH('Worksheet
1'!A1,{"Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday"},0))