Thread: How do I return the 10th day of the following month?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Statesman Statesman is offline
external usenet poster
  
Posts: 7
Default How do I return the 10th day of the following month?
This is GREAT!! Now I need to know how to roll the billing date to the 10th
of next month & year (ie: 01/10/07) when the current month is December (ie:
(12/08/06). Thanks!!

"Teethless mama" wrote:

=DATE(YEAR(A1),MONTH(A1)+1,10)

"Statesman" wrote:

From a "start date" in current month; I want to return a billing due date to
always be the 10th of the following month.
Reply With QuoteReply With Quote