Wednesday, 10 April 2013

Number '09 Question


so made chart track weight , wondering if there way make date column automatically fill in date next entry?
 

assuming want increment data same amount each time, 1 day put current date in top cell in column, next cell underneath next date, put formula references cell above +1 - see screenshot below. if mouse on bottom right hand corner of cell, see drag handle, drag down each day , copy formula down, incrementing date +1.

can see formula in cell c6, = c5 +1

extending range.png

hope helps.
 


Forums Macs Mac Apps and Mac App Store


  • iPhone
  • Mac OS & System Software
  • iPad
  • Apple Watch
  • Notebooks
  • iTunes
  • Apple ID
  • iCloud
  • Desktop Computers
  • Apple Music
  • Professional Applications
  • iPod
  • iWork
  • Apple TV
  • iLife
  • Wireless

No comments:

Post a Comment