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

johnkree

macrumors 6502
Original poster
Jun 23, 2015
296
294
Austria
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.