duration between 5/30/19 and 6/4/19?

djpreece

djpreece ✭✭

02/27/19 edited 12/09/19 in Formulas and Functions

Hi all,

2 in May and 2 in June right? 4 total

Why does the 2nd row show 3?

Darrell

Screen Shot 2019-02-26 at 6.58.47 PM.jpg

Tags:

Formulas

0 ·

Comments

Paul Newcome ✭✭✭✭✭✭

02/27/19

It looks like it is including the start date itself even though it is a weekend since it is a start date and not just tucked in the middle.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Trying to complete an INDEX MATCH formula
I am trying to create an INDEX/MATCH formula and the criteria used between the sheets for MATCH is: Sheet 1: First Name and Last Name in one column Sheet 2: Has 2 columns: first name and Last name I've tried to write a formula to combine the names on sheet 2 =[First Name]@row + " " + [Last Name]@row I've written many…
Formula column that counts the number of rows. Each row having its own number
The issue I am trying to resolve is that when the sheet has 500 rows i want automation to move a number of them elsewhere. lets say i want to move everything numbered from 350- 500. so i need each row to know how many rows there are so i can add automation so over 350 move rows. the problem i am having is i cant use…
I need to add a formula to check box column if SSN is in 2 different SmartSheet.