IF statement with range of dates

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Originally Posted by Jonmo1

That's pretty specific and should be simple with an if and function.

Try
=IF(AND(A1>=DATE(2015,11,26),A1<=DATE(2016,12,8)),DATE(2016,1,1),A1+31)

I'm not sure it is, hence my request for the workbook. The OP mentions "dates" (plural) in A1.

I actually can't attach one right now, I'm at work where the data is automatically encrypted (I can't do anything about it), but essentially My current calculator is very basic. It has A1 which can be manipulated, two cells (A2, A3) that are =a1+(x amount of days), and a cell (A4) for the first of the month following 60 days (=DATE(YEAR(A1+60),MONTH(A1+60)+1,1)). What I'm effectively trying to do is manipulate cell A4 further to have this information coincide with the information in my initial question. I realize that's pretty confusing without something to look at, and I'm not entire sure that its possible given the formula that is already in that box, but any tips would be greatly appreciated.

This related to enrollment dates, so the above cells coincide with various deadlines and A4 is the effective date. For open enrollment periods (a range of dates from November to December), the date will automatically become 1/1/2016. It's common sense information, however I need to present this to a group of new hires as a reference.

=IF(AND(B3>=DATE(2015,11,26),B3<=DATE(2016,12,8)),DATE(2016,1,1),B3+31) works, but I was wondering if there was a way to link (nest?) this formula with "=DATE(YEAR(A1+60),MONTH(A1+60)+1,1)"