Thread: Solve 1st of month after specified number of days elapsed
View Single Post
  #4   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
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
...





Reply With QuoteReply With Quote