Round up month

E

Edfermo

How do I calculate the "the 1st day of the month following 60 (or an
number of days) days
 
G

Guest

If you ALWAYS need to go to the first of the following month,
=date(year(today()+60),month(today()+60)+1,1). If that 60-day wait winds up
on the 1st and you then DON'T need to wait for the first of the following
month, make it conditional:
=if(day(today()+60)=1,today()+60,date(year(today()+60),month(today()+60)+1,1)).
 
R

Ron Rosenfeld

How do I calculate the "the 1st day of the month following 60 (or any
number of days) days"
Click to expand...


If I understand you correctly, you wish to add 60 to some date, and then find
the first of the month of that new date.

=A1+61-DAY(A1+60)


--ron
 

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
Vacation days from date of hire 15
Can I round a date to the 1st of the next month? 2
How to calculate a date: first day of the month after 60 days 12
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
Timesheet Calculate Sunday times that changes every month 2
ROUNDING UP monthly differences 7

Top