|When posting in a Help forum, please try to use a subject line that is relevant to the content of your post. If everyone used a generic subject such as Excel Formula, we wouldn't be able to tell one question from another. t would also makes the archives impossible to search.|
I have edited the subject of your post.
Try this formula:
=(A9+15) - DAY(A9+14)
Office Forum Moderator
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.