As I am revising my excel template for Retail Inventory, I realized there might be some people out there needing help or guide on how to use a dynamic dropdown, but do not want to include the blanks. Sample

Function Type: Date and Time Description: EDATE function in Excel or Google Sheets is used to return the serial number of the date that is the indicated number of months before or after the start date.

Function Type: Date and Time Description: DAYS360 function in Excel or Google Sheets is used to compute the number of days between 2 dates on a 360 days per year scale. This accounts for 12 months with

Function Type: Date and Time Description: DAYS function in Excel or Google Sheets is used to compute the number of days between 2 dates. This is equivalent to subtracting an End Date and a Start Date.

We can use Named Ranges to make our formula/functions easier to understand/audit. I just thought of sharing it as I clean up my templates. Here's a sample for a Revenue - Cost = Profit: Formula used in

Function Type: Date and Time Description: YEAR function in Excel or Google Sheets converts a serial number of a date to a day of the month. It returns an integer from 1990 to future years. You can use

Function Type: Date and Time Description: MONTH function in Excel or Google Sheets converts a serial number of a date to a day of the month. It returns an integer from 1-12 as we see in calendars. You

Function Type: Date and Time Description: DAY function in Excel or Google Sheets converts a serial number of a date to a day of the month. It returns an integer from 1-31 as we see in calendars. You can

Function Type: Date and Time Description: NOW function in Excel or Google Sheets returns the serial number of today's date and time. Like TODAY function, NOW function is mostly used in other functions,

Function Type: Date and Time In most cases especially in our dashboards and summary sheets, we want to have the date today automatically. Description: TODAY function in Excel or Google Sheets returns the

Function Type: Text I'm sure not everyone knows what the word concatenate means so I'll start this post with a screenshot of quick Google Search. Description: CONCATENATE function in Excel to concatenate

Function Type: Date and Time Description: DATEDIF function calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. In

Do you have expertise with Excel or Google Sheets? Think you are in the top 10% of Excel users worldwide? Here you can make up to $500/week with your knowledge on Excel or Google Sheets. $500/week may

Function Type: Logical Description: NOT function Reverses the logic of its argument. Any FALSE argument will result in TRUE. Any TRUE argument will result in FALSE. Logical test results in a TRUE or FALSE.

Function Type: Logical Description: OR function returns TRUE even if only one of its arguments are TRUE. Any TRUE argument will result in TRUE. Like AND function, this is most commonly used with IF function

Function Type: Logical Description: AND function returns TRUE if all of its arguments are TRUE. 1 FALSE argument will result in FALSE. This is most commonly used with IF function which also needs logical

Function Type: Math and Trigonometry Description: ABS function returns the absolute (positive) value of a number. If you only want the positive or magnitude of the number, this is the function you are

Function Type: Math and Trigonometry Description: The ROUND function in Excel or Google Sheets is used to round a number to a specified number of digits (decimal places). It is useful and frequently used

Function Type: Lookup and Reference Description: The INDIRECT function in Excel is used to convert a text string into a valid cell reference. It can be used to dynamically reference a cell or range of

Function Type: Lookup and Reference Description: The COLUMN function in Excel or Google Sheets returns the column number of a reference. Although we see alphabet being utilized as column indicators, this