DATE AND TIME Articles: Excel and Google Sheets

Figure 1. Pad Week Numbers With Zeros in Excel. If we want to pad week numbers with zeros in Excel, we have to make use of the TEXT function. Generic Formula =TEXT(WEEKNUM(date,type),"00") With the Excel TEXT function, we can "pad" any number value with as many zeros as we like....

Figure 1. Dynamic Date List in Excel. In order to set up a dynamic date list in Excel, we are going to use a formula syntax that allows us to automatically update it according to our specified parameters. Formula Syntax =start+ROWS(exp_rng)-1-offset start refers to our specified range of dates offset...

Data Validation in Excel allows you to create custom rules catered to your requirements. You can create a data validation using the SUM function to allow values, which added together, does not exceed a preset total. In this tutorial, you will learn how to create a data validation to only...

Figure 1. Excel Days Function. If we want to obtain a number representing days occurring between two specific dates in Excel, we must make use of the DAYS function. Formula Syntax =DAYS (end_date, start_date) start_date = A specified date from which Excel begins to count. end_date = A specified date...