I had a column of dates and would like to use a formula to determine the next dates which is 6 month away. I tried using =workday(A1,C1), where A1 to A50 is a series of date and C1 is 180(6mths), but the result give me more than 6 mths. I had tried using =date(2006,4+6,15) but i had too many dates to key that. I understand that Excel function of "workdays" and "Networkingday" refer to 5 days week. Is there any formula or function that I can use for 6 months for a equipment that is working 24/7 basis, Excel don't support this?