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)
|