15th of prior month

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

How do I display the 15th of the prior month?

A1 = 09-05-07
B1 = display 08-15-07
 
=((DATE(YEAR(A1),MONTH(A1),1))-31)+14

there must be a better way but it's all I could think of
 
How do I display the 15th of the prior month?

A1 = 09-05-07
B1 = display 08-15-07
Click to expand...

A bit different way:

=A1-DAY(A1)-DAY(A1-DAY(A1))+15


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date formula returns the 15th or the end of month 8
Difference between last date of month and given date 3
Mid-Month function help 3
Retrieving data based on most recent date 1
Formula help needed 2
Help needed with a formula for dates in excel 2007 2
Date if before or after 15th of month 4
3 months prior and 3 months post a date 2

Back
Top