Thread: 15th of prior month
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deb Deb is offline
external usenet poster
  
Posts: 12
Default 15th of prior month
How do I display the 15th of the prior month?

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

Reply With QuoteReply With Quote