I am using the edate formula edate(A1,1). Cell A1 is 01/31/2006. The next date is 02/28/2006 however all subsequent days are now the 28th of each month, not the actual last day of the month. Can you please advise how I can correct this formula?