View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Need help displaying odd numbered month

Thanks for your feedback. I am happy that you found the mistake in my formula
and corrected it...

"Greg L" wrote:

With your help I finally got it. Thanks!
Here is what I ended up with:

=DATE(YEAR(TODAY()),(MONTH(TODAY())+IF(DAY(TODAY() )10,IF(MOD(MONTH(TODAY()),2)=1,2,1),IF(MOD(MONTH( TODAY()),2)=1,0,1))),10)