using date boundaries
Hello SS community,
I'm having trouble figuring out the right formula for having SS return the amount of days scheduled within a two dates. I need it to provide only positive numbers and zero for negative values. My columns are: Start date| Finish Date| Duration| Goal period start date| Goal Period end date| Goal Duration|. The formula would be in the Goal Duration column calculating the number of days from the Start Date/End Date columns that fall within the Goal Period Start Date and Goal Period End Date.
Thanks in advance for any help on this.
Help Article Resources
Check out the Formula Handbook template!