Skip to content
ExcelSirJi
  • Home
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
ExcelSirJi

Excel formulas

Home / Excel formulas
Excel Function – WEEKNUM Function
Excel Formula Tips

Excel Function – WEEKNUM Function

Byexcelsirji
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...

Read More Excel Function – WEEKNUM FunctionContinue

Excel Function Replace
Excel Formula Tips

Excel Function Replace

Byexcelsirji
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,...

Read More Excel Function ReplaceContinue

EXCEL FUNCTION – NETWORKDAYS
Excel Formula Tips

EXCEL FUNCTION – NETWORKDAYS

ByPradeep Kumar

“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.

Read More EXCEL FUNCTION – NETWORKDAYSContinue

Excel Function – SUBTOTAL
Excel Formula Tips

Excel Function – SUBTOTAL

Byexcelsirji

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…

Read More Excel Function – SUBTOTALContinue

  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2022 ExcelSirJi

  • Home
  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
Search