Function Type: Date and Time Description: EOMONTH function in Excel or Google Sheets is used to return the serial number of the last day of the month before or after a specified number of months. Function Structure: =EDATE(start_date,months) Arguments start_date – this is the date or serial number representing the start date in a validContinue reading “EOMONTH function”
Category Archives: Spreadsheet Tutorials — Excel and Google Sheets for Personal Finance
How to do Dynamic Dropdown without blanks in Excel step by step guide
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 Problem Description 1: I want to make a dropdown list in excel using Setup!$C$15:$C$44 range butContinue reading “How to do Dynamic Dropdown without blanks in Excel step by step guide”
EDATE function
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 Structure: =EDATE(start_date,months) Arguments start_date – this is the date or serial number representing the start date months –Continue reading “EDATE function”
DAYS360 function
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 30 days for each12months x 30days = 360This is equivalent to subtracting an End Date and a Start Date,Continue reading “DAYS360 function”
DAYS function
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. Function Structure: =DAYS(end_date,start_date) Arguments end_date – this is the date or serial number representing a the end date start_date –Continue reading “DAYS function”
YEAR function
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 YEAR function to get the MONTH number from your TODAY function or NOW function which can be usedContinue reading “YEAR function”
MONTH function
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 can use MONTH function to get the MONTH number from your TODAY function or NOW function which canContinue reading “MONTH function”
NOW function
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, dashboards and summary sheets. TODAY function gives us an integer serial number while NOW function gives us a serial number with decimalContinue reading “NOW function”
Debt Snowball Chart Excel Template
Debt Snowball is a payoff method used to be free from debts. Paying your debt more than the minimum amount required. Like a snowball, it starts paying off debts from the smallest amount to the highest. One might argue that prioritizing the highest interest rate debts should be prioritized, but due to the nature ofContinue reading “Debt Snowball Chart Excel Template”