Frilanser:
cziner
Excel Formula
The 1st screenshot is displaying the exact formula you need. >Please apply this formula carefully using the Cell-reference[C6 or $C6] & Separation[, or ;] indicating rules of your software. To be sure of these rules you may try applying a simple formula on a cell [suppose L6] using 'Formula' menu of the software. Steps are shown in my last 3 screenshots. >If "#NAME?" error occures, you have misspelled the formula, retype and double check. If any problem still persists please let me know. Waiting to listen from you. Thanks!
Offentlig avklaringstavle
-
cziner
- 7 år siden
>This formula gives the intended result for both before and after year 2000.
- 7 år siden
