Need an Excel formula to add 21 days to a date and return the 1st of that month. 2/15/11 + 21

Answer

3/1/11

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)

DerbyDad03

Office Forum Moderator

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History