Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

johnkree

macrumors 6502
Original poster
Hello...

I'm fiddling around in Numbers. I'd like to enter a day in one cell and to autofill 4 other cells for the other days of the week. My problem is that the cells are merged cells, so the usual autofill won't work.

Is there a function that says something like A1=entered date. A6=entered date + 1day?

I would be so happy if there is something like that.
it would safe me so much time.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.