Time and Date Question

  • Thread starter Thread starter wx4usa
  • Start date Start date
W

wx4usa

I have column A with date (mm,dd,yyy) I would like excel to
calculate....the first day of the month following 3 months after the
date entered.

In other words, date entered is 10/07/2007, excel should return
February 1, 2008. 3 full months would be January 7, 2007 (or8th) and
the answer returned should be the 1st of the next month after 3 full
months.

Thank you all so much for all of your help on my numerous posts! This
is a fabulous group of professionals always willing to help!
 
I have column A with date (mm,dd,yyy) I would like excel to
calculate....the first day of the month following 3 months after the
date entered.

In other words, date entered is 10/07/2007, excel should return
February 1, 2008. 3 full months would be January 7, 2007 (or8th) and
the answer returned should be the 1st of the next month after 3 full
months.

Thank you all so much for all of your help on my numerous posts! This
is a fabulous group of professionals always willing to help!
Click to expand...

Actually, better stated would be rounded to the beginning of the
month following 90 full days of the date on column A. For Example, an
employee would be eligible for medical coverage on the 1st of the
month after 90 days of employment
 
Actually, better stated would be rounded to the beginning of the
month following 90 full days of the date on column A. For Example, an
employee would be eligible for medical coverage on the 1st of the
month after 90 days of employment
Click to expand...


=A1+123-DAY(A1+90)-DAY(A1+122-DAY(A1+90))

or, perhaps easier to understand:

=DATE(YEAR(A1+90),MONTH(A1+90)+1,1)

The above formulas are very literal to your specifications. In other words, if
the 90th day of employment is 5/1, the date will be rounded up to 6/1.
--ron
 
Try this
=DATE(YEAR(A1),MONTH(A1)+3,1)

Ron Rosenfeld said:
=A1+123-DAY(A1+90)-DAY(A1+122-DAY(A1+90))

or, perhaps easier to understand:

=DATE(YEAR(A1+90),MONTH(A1+90)+1,1)

The above formulas are very literal to your specifications. In other words, if
the 90th day of employment is 5/1, the date will be rounded up to 6/1.
--ron
Click to expand...
 
Try this
=DATE(YEAR(A1),MONTH(A1)+3,1)
Click to expand...

Did you try this solution?

Aside from the fact that the OP changed his original request from 3 months to
90 days, your solution rounds down and doesn't work on the example the OP gave.

--ron
 
Back
Top