Is there a way to calculate Netdays using 2 sets of dates

I have 4 columns with dates (they are set as date columns). Here is what I want to do using the following example:

  • These are the 4 columns with their values:
    • Check-In Date: 01/27/2024
    • Check-Out Date: 02/10/2024
    • Start Date: 01/01/2024
    • End Date: 02/04/2024


  • The Netdays between the Check-In Date and Check-Out Date = 15
  • But the Netdays of the Check-In Date and Check-Out Date that fall between the Start Date and End Date = 9

Is there a way to calculate the Netdays within a date range this using a formula?


Thanks in advance.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!