View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Can I round a date to the 1st of the next month?

With your original date in cell A1. If this is first of the month AFTER 60
days have expired:

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

if this is the first of the month where 60 days expi

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

HTH. Best wishes Harald

"Linda M" <Linda wrote in message
...
I am trying to develope a worksheet that gives me the eligiblity date of an
employee (i.e. 1st of the month after 60 days).