Thread: How do I return the 10th day of the following month?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 698
Default How do I return the 10th day of the following month?
Try this:

A1: (a date)

This formula returns the 10th day of month after the month containing A1

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

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"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