Welcome to Our Career Site
- How to be successful at entry level Accounting jobs
- How to be successful as a Staff Accountant
- How to be a successful auditor
- How to be a successful Forensic Accountant
- How to be a successful Management Accountant
- How to be a successful Tax Accountant
- How to integrate Technology in Accounting
- How to integrate AI in Accounting
- Top 100 Accounting Questions for Entry level
- Excel formula for Accounting-part 1
- Excel formula for Accounting-part 2
- Excel formula for Accounting-part 3
- Excel formula for Accounting-part 4
- Excel formula for Accounting-part 5
Job Listings
Explore the latest requirement for accounting jobs.
Click on the links to the left to learn more about specific aspects of accounting jobs.
Important Excel Formulae for Accounting-Part 4
Set 9: Advanced Date Functions
EDATE: Returns the date that is a specified number of months before or after a specified date.
EOMONTH: Returns the last day of the month that is a specified number of months before or after a specified date.
NETWORKDAYS: Returns the number of whole workdays between two dates.
WORKDAY: Returns the date before or after a specified number of workdays.
YEARFRAC: Returns the year fraction representing the number of whole days between start_date and end_date.
Set 10: Error Handling Functions
ISERROR: Returns TRUE if the value is any error value.
ISERR: Returns TRUE if the value is an error value other than #N/A.
IFNA: Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
ERROR.TYPE: Returns a number corresponding to one of the error values.
ISNA: Returns TRUE if the value is the #N/A error value.