Thread: 15th of prior month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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


Reply With QuoteReply With Quote