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

  • Thread starter Thread starter Linda M
  • Start date Start date
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).
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Message box with days of month & date. 1
How to calculate a date: first day of the month after 60 days 12
Vacation days from date of hire 15
Outlook 2016 Calendar printing monthly view 0
Excel Vba to change displayed year automatically. 14
formula to return 1st of the month following 60 days 3
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
YEAR MONTH DAYS COUNTER 3

Back
Top