The excel formula works. Thanks and Great but i still miss the understanding. Can you please help explain the logic? How entering the formula in one cell does fill the dates for the cells in the row?