hi Mr. H2, welcome to the forum. your cells in "FTE Activation" C4:C5 is somehow not captured as a Date. copy the cells from C3 & paste it below. if you realise, C3 in the formula bar reads:
20/2/2013 (or maybe in your region settings 2/20/2013)
but C4 & C5 are plain texts:
February 20,2013
the latter is not recognised in formulas. with that, use this array formula in "Deployment" sheet I3:
you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER. When done correctly, you should see curly brackets surrounding it. then copy down & across
Bookmarks