Thread
:
Calculate a Date
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
Posts: 5,651
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
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld