Thread: 15th of prior month
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default 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
Reply With QuoteReply With Quote