Can I round a date to the 1st of the next month?

L

Linda M

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

Harald Staff

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 expire:

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

HTH. Best wishes Harald
 
T

T. Valko

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
 
Top