by Rajesh Saraogi | Jun 14, 2020 | Formula & Functions, Text Functions
Goal: To generate Ordinal Number and Ordinal Date in excel. An Ordinal Number is a number that tells the position of something in a list, such as 1st, 2nd, 3rd, 4th, 5th etc. An Ordinal Date denotes the position of a day in a given month and year; e.g., 8th June, 2020...
by Rajesh Saraogi | Jun 8, 2020 | Formula & Functions, Formula Basics
The real strength of Excel is its calculation power. An excel worksheet without any calculation can also be created in an MS Word (.doc or .docx) file. This post will help to understand excel formulas, from simple calculations to advanced ones, with nested built-in...