Excel 2007 : Invoice due dates formula (Rounding date to end of month)

[benoj2005]

Due Date Terms Formula.xlsx

See Column C attached, just need the formula in C2 & C3 to round up to the end of the month (See column D for correct answer)

Thanks

[Pepe Le Mokko]

Hi try =EOMONTH(C2,0) and pull down as needed

[benoj2005]

Ok so I need a column adding the 30days onto the invoice date and then another column converting that to end of month using EOMONTH formula. Shame it can't all be done in one, but it works, thanks

[Pepe Le Mokko]

You didn't emphasize that you wanted it all in one go.
So, try =EOMONTH(A2+30,0)

EDIT : BTW, your formula in col C =+A4+30 does not need a "+" between the equal sign and the reference ( Lotus 123 syntax)

[benoj2005]

Ah thanks, didnt think of combining it.

yea i just type + to start a formula by habit because my hands on the number pad, then when you enter it adds the equals infront.