15th of prior month

  • Thread starter Thread starter Deb
  • Start date Start date
=((DATE(YEAR(A1),MONTH(A1),1))-31)+14

there must be a better way but it's all I could think of
 

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