The =EOMONTH function is a handy way to determine the last day of a given month. However, that function requires that you have the Analysis ToolPak installed and enabled (users often don't). Instead, use the =DATE function. For instance, =DATE(2000,1,0) will return 12/31/99. You can also use this technique in your VBA macros and functions.