View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Benefits Eligibility Dates

=DATE(YEAR(A2+180),MONTH(A2+180)+1,1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Yvonne" wrote:

I am looking for a formula that helps me define 1st of the month or 1st of
the quarter following 30, 90, and 180 days after hire date.

So, I have the hire date in a cell and the next cell I want to see the date
for 1st of the month following 180 days after hire date.

Thanks in advance,