Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbered columns? | Excel Discussion (Misc queries) | |||
create numbered sortable numbered list in excel | Excel Discussion (Misc queries) | |||
Numbered Lists - Take 2 | Excel Discussion (Misc queries) | |||
Numbered Lists | Excel Discussion (Misc queries) | |||
Numbered Lists! | Excel Discussion (Misc queries) |