DATE & TIME HELP: I need to have 6 rows to show a date and the next 6 rows to be the next day all in the same column. For Example the first 6 rows show 7/31/15 and the next 6 rows show 8/01/15 to save me the trouble of typing them in every day.
MacBook Air (13-inch Mid 2013), OS X Yosemite (10.10.4)
Hi Richard,
an easy approach to this:
This is from a table that gets multiple same day entries but I never know how many. The formula is filled down. when I need a new date I delete the formula and enter the date. The following cells echo the new entry. This would require a daily date entry from you.
Automating the whole thing like you asked:
I suspect there would be problems if you delete or add a row.
quinn
Hi Richard,
an easy approach to this:
This is from a table that gets multiple same day entries but I never know how many. The formula is filled down. when I need a new date I delete the formula and enter the date. The following cells echo the new entry. This would require a daily date entry from you.
Automating the whole thing like you asked:
I suspect there would be problems if you delete or add a row.
quinn
you can enter a valid date and add 1 to it. this implies add one day. If you want to me verbose you could add a duration of 1 day like this:
In cell A2 enter
=A1 + "1d"
short hand would be:
A2=A1 + "1d"
select A2, copy
select A2 thru A8, paste
DATE
