View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Calculate a Date

On Mon, 8 Sep 2008 18:27:56 -0600, "Fred Smith" wrote:

Use this formula:

=date(year(a1)+2,month(a1)+1,0)

Regards,
Fred.



That does not return the first of the month
--ron