Similarly, TODAY()-3 is three days before today or 05/04/2021. This is because dates are basically stored in Excel as serial numbers, starting from the date Jan 1, 1900. It may not display this or other websites correctly. The IF function is one of the most useful Excel functions. I had forgotten about the 'first of month' exception. If you have a list of random dates, how could you convert them to the first day of these given month as following screenshot shown? Bargaining unit or Managerial & Professional staff member scheduled to work at least 20 hours per week. Using a hire date of 7/1/17 my script results in 7/31/17, I need to calculate it to 8/1/17. Best Review Site for Digital Cameras. I hope the tips covered here were useful for you. The MONTH function returns the number 1 representing the month ( January) of the date. If you really want to get the same date of next month based on date 2016/10/31, please use this formula =IF(DAY(EDATE(A2,1))