View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MH MH is offline
external usenet poster
 
Posts: 28
Default Solve 1st of month after specified number of days elapsed

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