Calculating dates

[gopherc4]

I am trying to calculate dates that will happen 16 days from date specified in column A (A23:A200), based off a certain entry in Column B (B23:B200), which is named in cell P5. I can get the date by doing the specified date + 16, e.g. =IF($B$23:$B$200=$P$5,$A23+16,"")

The trouble I am running into is not having the date populate until it has reached 16 days from the dates in column A, show blank if possible until 16 days from date in column A.

The dates in column A will always be previous to todays date.

[JBeaucaire]

Hmm, a little convoluted, and I'm not testing your original formula without your sheet posted, so to add a date-check into the mix, try this:

=IF(AND($B$23:$B$200=$P$5,TODAY()>=$A23+16),$A23+16,""))

[gopherc4]

That worked fine. Exept for the extra close parathesis on the end.