View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Can I round a date to the 1st of the next month?

If you have a date in cell A1:

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

This one requires the Analysis ToolPak add-in be installed for Excel
versions prior to Excel 2007:

=EOMONTH(A1,0)+1

Format as Date

--
Biff
Microsoft Excel MVP


"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).