You can use the Text Function as well as Format Cell option to display weekday for a date in excel. Using Text Function display with formula and format cell option is done without any formula.
Dynamic Hyperlink helps you create hyperlinks to navigate to different worksheets within a workbook. Learn how to create a dynamic link in just 3 easy steps. Simple hyperlinks are static. A hyperlink that changes based on the selection or any action by the user is called a dynamic hyperlink. This function is helpful when you […]
You can COUNTIF to Compare two dataset with frequent repetition of items which counts the number of cells in the selected dataset which meets the given criteria.
SpellNumber European Euros, a manually created function in using VBA coding to displays a given number in words with European Euros as currency. There is no SpellNumber function in excel. Microsoft has given a code for SpellNumbers USD. You need to manually create this function in the workbook following some easy steps. Using SpellNumber will […]
SpellNumber Japanese Yen is a manually created Excel function using VBA Programming. It displays a given number in words as Japanese Yen. SpellNumber is not an inbuilt function in excel. Microsoft has provided a code for Spell Numbers for US Dollars. We have to manually create this function manually for every workbook in which you […]