Elf,

You can use EOMONTH. You need to have the Analysis ToolPak. To
install go to ToolsAddins. Select the Analysis ToolPak check box.
Then you can apply this formula in A2.

=EOMONTH(A1,0)-A1

Format A2 as General. You can then copy this down as needed.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524961