Excel Formula to Return 1st of Month

January 14, 2011 at 10:21:46
Specs: Windows XP
Need an Excel formula to add 21 days to a date and return the 1st of that month.

2/15/11 + 21


See More: Excel Formula to Return 1st of Month

Report •

January 15, 2011 at 18:26:49
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.

Report •
Related Solutions

Ask Question