Thread: How do I use "if statements" when working with dates?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default How do I use "if statements" when working with dates?
will this work?
=DATE(YEAR(G3),MONTH(G3)+IF(DAY(G3)<10,0,1),10)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Statesman" wrote in message
...
I need...formula if the day of the current date is 10th, then due date
will
be 10th of following month. Otherwise, due date will be 10th of current
month.

Reply With QuoteReply With Quote