Thread: I want to add 6 months to a certain date in a formula (Excel)
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default I want to add 6 months to a certain date in a formula (Excel)
On Thu, 6 Jul 2006 11:27:08 +0100, "Bob Phillips"
wrote:

=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )

Verry nice. Finally, a concise substitute for the EDATE ATP function.
--ron
Reply With QuoteReply With Quote