number of days between one state and another (not including weekends)
I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this?
date of creation| Name | Status | DAYS WITH THAT STATUS
03/03/2018 | cristian | busy | 1
02/27/2018 | cristian | available | 4
02/26/2018 | cristian | busy | 1
02/26/2018 | Carolina | available | 5