Knowledge Hub
Microsoft Excel
Practical Excel formulas, templates and dashboards for IE and production teams.
All204
Industrial Engineering27
Production Planning25
Lean & Six Sigma25
Microsoft Excel71
Quality12
Textile & Thread2
Sewing Machines19
Maintenance5
Utility5
Merchandising5
Store & Inventory5
Garments Industry3
Microsoft Excel
UPPER Function in Excel
UPPER converts all characters in a text string to uppercase.
Microsoft Excel
EDATE Function in Excel
EDATE returns the same day a number of months before or after a date.
Microsoft Excel
YEARFRAC Function in Excel
YEARFRAC returns the fraction of a year between two dates.
Microsoft Excel
WEEKDAY Function in Excel
WEEKDAY returns the day of the week as a number.
Microsoft Excel
WORKDAY Function in Excel
WORKDAY returns the date a number of working days before or after a start date.
Microsoft Excel
NETWORKDAYS Function in Excel
NETWORKDAYS counts working days between two dates, excluding weekends and holidays.
Microsoft Excel
EOMONTH Function in Excel
EOMONTH returns the last day of a month a number of months before or after a date.
Microsoft Excel
DATEDIF Function in Excel
DATEDIF calculates the difference between two dates in years, months, or days.
Microsoft Excel
DATE Function in Excel
DATE builds a valid Excel date from separate year, month, and day values.