Here the return value in cell E3 is formatted using dd-mm-y. For months, use a positive value for future dates and a negative value for dates in the past.ĮDATE returns the value in serial date but mostly we want formatted date rather than a serial date. Click it, there are two common used options: Freeze Top Row and Freeze First Column. One can use EDATE to get the same date in the future or past months. Switch to View tab in Excel, find the feature called Freeze Panes in the Window section. Let’s look at some examples of EDATE Function. Then choose the Freeze Panes command from the drop-down menu. Then click the Freeze Panes button in the Window button group. If months are not an integer, it is truncated. To freeze panes in both columns and rows in a worksheet, select the cell below the row and to the right of the column to freeze. Freeze obere Zeile Unfreeze Panes Freeze-Bereiche Wenn Sie eine groe Tabelle mit Daten in Excel haben, kann es ntzlich sein, Zeilen oder Spalten einzufrieren.If start_date is not a valid date, EDATE returns the #VALUE! error value.
By default, January 1, 1900, is serial number 1, and January 1, 2008, is serial number 39448 because it is 39,448 days after January 1, 1900.
Say you want to freeze the top four rows and leftmost three columns. Use a positive value for months to get a date in the future, and a negative value for dates in the past. To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes.
You can use EDATE to calculate expiration dates, maturity dates, and other due dates. The EDATE function returns date on the same day of the month, n months in the past or future.