Excel Function – WEEKNUM Function
Watch Excel Tutorial Video - Excel Function – WEEKNUM Function WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and...
Excel Function Replace
How to use “REPLACE” function in Excel REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num,...
EXCEL FUNCTION – NETWORKDAYS
“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.
Excel Function – SUBTOTAL
Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use this function for…