File renaming applications are great if you need to rename a lot of files. They can be even better if you can use Excel’s built-in functions such as TRIM, SUBSTITUTE, FIND, LEFT, and RIGHT in order to clean up and generate your new file names. Excel VBA File Renamer for Windows is my take on the idea and can be downloaded here: dailyexcel.net Excel VBA File Renamer for Windows dailyexcel.net Excel VBA File Renamer for Windows enables you to …
Tag: NOT function
Calendar
Dynamic Calendar Template for Excel is now available for download: dailyexcel.net calendar dailyexcel.net calendar currently supports 10 scenarios/countries for years from 2024 to 2028: No single workday rule, as well as three additional from-to periods, are available for collective vacation planning. Hours worked in a week, as well as holiday and vacation hours, are automatically calculated in order to support planning of business days. For supported scenarios, holidays are automatically downloaded via connection to the dailyexcel.net site: …
Generate lists of working and non-working days
You will sometimes need to generate a sequence of working and/or non-working dates in Excel. In principle, the simplest way to accomplish this is to combine the SEQUENCE function with the FILTER function. The SEQUENCE function generates a list of sequential numbers. The SEQUENCE function syntax is as follows: =SEQUENCE ( rows ; [columns] ; [start] ; [step] ) Rows specifies the number of rows to fill. Columns specifies the number of columns to fill. If omitted, 1 column …
Conditional statements
IF function basics Conditional statements, conditional expressions, conditional processing, IF-THEN, or IF-THEN-ELSE are all names for a programming concept where conditions are tested and actions are performed if conditions are met. If a certain condition is met, something is calculated. If that certain condition is not met, either nothing happens or something else is calculated. In Excel, when conditions are met, something is TRUE. When conditions are not met, something is FALSE. TRUE and FALSE are logical values. You will …