Learn how to convert serial numbers to date in Excel using TEXT function, number formatting, and VBA macro codes.| Spreadsheet Planet
Learn how to find the last Monday of the month in Excel using a single formula, involving the EOMONTH and WEEKDAY functions.| Spreadsheet Planet
Learn how to use the IF function with dates in Excel with easy examples. Compare dates, use operators and DATEVALUE and TODAY functions.| Spreadsheet Planet