View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greg L[_3_] Greg L[_3_] is offline
external usenet poster
 
Posts: 10
Default Need help displaying odd numbered month

I'm trying to get the odd numbered month (Jan[1], March[3], etc) and
display the next tenth of that month.

For example: If its the 9th of Jan, display 1/10/current year
1/10 display 1/10
1/11 display 3/10
2/1 display 3/10

11/9 display 11/10
11/10 display 11/10
11/11 display 1/10/next year

I'm almost there, but I can't get the syntax correct for the month
number. It works fine prior to the 10th, but after the 10th it
displays the current month during an odd month. I know I'm missing an
IF statement.

=DATE(IF(TODAY()DATE(YEAR(TODAY()),11,10),YEAR(TO DAY())+1,YEAR(TODAY())),IF(TODAY()DATE(YEAR(TODAY ()),11,10),1,ODD(MONTH(TODAY()))),10)

Am I just making this more confusing than it has to be?
I know the last false statement is the trouble "ODD(MONTH(TODAY()))",
but I can't get my head around it for some reason.

TIA