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
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