15th of prior month

Thread view:

Thread rating:

Deb - 06 Feb 2007 20:10 GMT

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

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

Gary''s Student - 06 Feb 2007 20:34 GMT

=DATE(YEAR(A1),MONTH(A1)-1,15)

Signature

Gary's Student
gsnu200704

> How do I display the 15th of the prior month?
>
> A1 = 09-05-07
> B1 = display 08-15-07

Mike - 06 Feb 2007 20:41 GMT

=((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

Ron Rosenfeld - 06 Feb 2007 21:48 GMT

>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