Dates Duplication

Hi

I need some help developing a date formula. In the attached workbook is a sheet for each month. For each Job, on the JAN sheet, I have entered the date in the Date field.

I need a formula on the FEB thru DEC sheets, that will take the day part (2nd, 15th, 30th) of the JAN dates and use these for the day in the dates for each Job, in the other months.

So, on the FEB sheet, the first two dates would be 2/2/15 and 2/15/15. I’m not sure how Excel will handle the last date, but I am thinking the last FEB date would be 2/28 or 29, depending if leap year or not. Otherwise, on MAR (thru DEC) sheets the dates would be 03/2/15, 03/15/15 and 03/30/15, and so on, the same days as in JAN.

Thanks for all your help.

For Feb sheet

B14 : 2/2/15
B15 : B14+13
B16 :

Please Login or Register  to view this content.

Sktneer, your code worked just right. Thanks so much.