Thread: Round up month
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default Round up month

On Wed, 30 Nov 2005 13:30:15 -0600, Edfermo
wrote:


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



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