| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
| 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) | |||
Threaded Mode
