ExcelBanter - 15th of prior month

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - 15th of prior month (https://www.excelbanter.com/excel-worksheet-functions/129533-15th-prior-month.html)

Deb

15th of prior month

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

A1 = 09-05-07
B1 = display 08-15-07

Gary''s Student

15th of prior month

=DATE(YEAR(A1),MONTH(A1)-1,15)
--
Gary's Student
gsnu200704

"Deb" wrote:

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

A1 = 09-05-07
B1 = display 08-15-07

Mike

15th of prior month

=((DATE(YEAR(A1),MONTH(A1),1))-31)+14

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

"Deb" wrote:

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

A1 = 09-05-07
B1 = display 08-15-07

Ron Rosenfeld

15th of prior month

On 6 Feb 2007 12:10:52 -0800, "Deb" wrote:

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

A1 = 09-05-07
B1 = display 08-15-07

A bit different way:

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

--ron

All times are GMT +1. The time now is 05:51 PM.