I have a 50,000 row spreadsheet with information such as company, names and dates. Every company has a starting date of 4/8/15 and successive entries in the date column (within each company) are 14 days apart. So person 1 has a date of 4/8/15 while person 2 has a date of 4/22/15 and so forth.
Does anyone know how to generate the dates automatically for each person in a company so that I won't have to do it manually?
Company name date
ACME USA person 1 4/8/2015
ACME USA person 2 4/22/2015
ACME USA person 3 5/6/2015
ACME USA person 4 5/20/2015
Fake Company 1 person 1 4/8/2015
Fake Company 1 person 2 4/22/2015
Fake Company 1 person 3 5/6/2015