I can use the NetWorkingDays() formula but that removes weekends and it defeats the purpose. I am pretty sure that I am missing something obvious. Help is really appreciated.
I am pretty sure that number of nights between two dates equals to number of days between them, e.g.:
ToDays(Date(2019, 5, 17) - Date(2019, 4, 10))
I was going to ask for the time boundary of night - what time it starts and ends.
Thank you Denis, that’s it. And how do I use the dates from two other columns that are already in the table with that formula?
I think I got it, I was over complicating things. I just did ="nameofrow2-“nameofrow1” and the result was what was expected in days.