|or would I need to place the start/end date in different columns|
Using two cells for your Start Date & End Date like:
1) 9/1/2015 10/15/2015
In cell C1 enter the formula:
See how that works for you.