Hi Saarang84

Unfortunately the pay period (23/2013) will change over time, and it can't be moved from (cell B1).

It can be formatted as dd/yyyy, as can all of the pay period in column A of the pay calanders sheet. Is that what you mean?

I'm not sure what you mean by input and output, the only two inputs are does the first 3 characters of the text string in C3 = "ABC", and if so is the end date of the pay period (23/2013)+3 days <= the DDMM of the DOB. The outpit is simply a Yes or blank, or any other text string.

Does that help?

Thanks