I am looking for a formula that will allow me to have a date that is 1st of the quarter after 180 days of employment.
So, for instance in first column is hire date, in second column is the date that will be 1st of quarter after 180 days employment.
Date of Hire 3/16/2009
1st of quarter date would read: 10/01/2009
So, for instance in first column is hire date, in second column is the date that will be 1st of quarter after 180 days employment.
Date of Hire 3/16/2009
1st of quarter date would read: 10/01/2009