View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Solve 1st of month after specified number of days elapsed

You're welcome!

Biff

"MH" wrote in message
...
Thank you.

"T. Valko" wrote:

Or, for the 1st of the month for the *next* month:

=DATE(YEAR(Date + n),MONTH(Date + n)+1,1)

Biff

"T. Valko" wrote in message
...
Date + n - DAY(Date + n) + 1

Biff

"MH" wrote in message
...