Formula - First of month following # of days

[vwachieve]

I'm trying to figure out how to create a formula to show result of the following;

60 days from date and first of the following month.

For instance, 6/17/08 + 60 days and the first of the following month would be 9/01/08.

 

[Mike Blackman]

Hi and welcome to the board,

If you install the Analysis Toolpak then the below will do what you require;

=EOMONTH(A1+60,0)+1

 

[barry houdini]

Without using Analysis ToolPak functions try

=DATE(YEAR(A1+60),MONTH(A1+60)+1,1)

or, here's one I don't recommend.......but it'll give you the correct result

=A1+100-DAY(A1+60)-DAY(A1+99-DAY(A1+60))

 

[Gerald Higgins]

Hi vw, welcome to the board.

Maybe something like this (assumes target date is in A1)

=eomonth(A1+60,0)+1

You need the Analysis Toolpak Add In to be activated to use eomonth.

 

[Gerald Higgins]

Also, bear in mind that if February falls within the 60 days, you might get some unexpected results . . . .

 

[vwachieve]

I don't have the Aanlysis ToolPak function, so the solutions without using the toolpak work best for me.

They all worked................


Thank you everyone for your assistance!

VW

 

[Gerald Higgins]

I don't have the Aanlysis ToolPak function

OK, but you can easily activate it if you like.

 

[vwachieve]

What is the procedure to activate it?

 

[Gerald Higgins]

Tools, AddIns, should give you a list of Add Ins which are available, including the Analysis Toolpak.

Put a tick next to it, and OK it.

 

[vwachieve]

I have MC Excel 2007 version. What version are you referring to?