H hamiltoncruiser Nov 22, 2007 #1 How do I tell Excel 2007 to calculate the last day of the month .....Lisa
R Ron Rosenfeld Nov 22, 2007 #3 How do I tell Excel 2007 to calculate the last day of the month ....Lisa Click to expand... =DATE(year(dt),month(dt)+1,0) or =EOMONTH(dt,0) dt can be an actual date, or a reference to a cell containing a date. --ron
How do I tell Excel 2007 to calculate the last day of the month ....Lisa Click to expand... =DATE(year(dt),month(dt)+1,0) or =EOMONTH(dt,0) dt can be an actual date, or a reference to a cell containing a date. --ron
M Marcelo Nov 22, 2007 #4 If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. -- regards from Brazil Thanks in advance for your feedback. Marcelo "hamiltoncruiser" escreveu:
If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. -- regards from Brazil Thanks in advance for your feedback. Marcelo "hamiltoncruiser" escreveu:
