View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default 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