Lab Productivity

Originally Posted by newdoverman

I did it manually as it is a "one of" as an example of how to input data so that it is actually useful to create reports with. This was quickly done mostly with copy and paste.
If you want to quickly enter the dates so that you have 3 of the same date then increment by one day, this formula will do that. It assumes the dates to actually start in A3 and go down the column. A date preceding the actual start date by 1 day is entered in A2.
Enter this in A3 and fill down and format as a date.

Formula:

=IF(MOD(ROW(),3)=0,MAX(A$1:$A2)+1,A2)

	A
2	31/12/2015
3	01/01/2016
4	01/01/2016
5	01/01/2016
6	02/01/2016
7	02/01/2016
8	02/01/2016
9	03/01/2016
10	03/01/2016
11	03/01/2016
12	04/01/2016
13	04/01/2016
14	04/01/2016
15	05/01/2016
16	05/01/2016
17	05/01/2016
18	06/01/2016
19	06/01/2016
20	06/01/2016
21	07/01/2016
22	07/01/2016
23	07/01/2016
24	08/01/2016
25	08/01/2016

THX AGAIN newdoverman