| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modifying a complex date formual to count months
Thank you for your feedback
In article , Charabeuh writes =IF(ISNUMBER(B21),IF(MOD(B21,12)=1,"Year "&0&0+INT(B21/12),REPT("0",2-LEN(2+MOD(B21-2,12))) &( 2+MOD(B21-2,12))),"") HI Yes - that's fantastic. It worked perfectly first time. Thank you for your time and considerable expertise. Best Wishes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Count Formual with checked boxes | Excel Worksheet Functions | |||
| formual to determine if date falls on weekend, adjust date to Mond | Excel Discussion (Misc queries) | |||
| need help modifying a complex column of formulas | Excel Discussion (Misc queries) | |||
| Count months away betwwen a strat and end date by month | Excel Worksheet Functions | |||
| count number of months year to date | Excel Worksheet Functions | |||
![Charabeuh[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
