Hi,
I am agonizing over a function that will allow me to subtract a value of -1 every one day from the number in the “Days” column. The function is supposed to start counting when TODAY()>=“Date Start”.
I made such a function in the “Days count” column but it shows the range always smaller by 1(when there are no weekends) and when there are weekends by (-1, -2, -3 etc) depending on how many weekends it has along the way.
Here is my function from the Days count column:
IF(TODAY()>={Date Start},
IF(Weekends="with weekends", DATETIME_DIFF({Date end},TODAY(),'d'),
IF(Weekends="without weekends", DATETIME_DIFF({Date end},{Date Start},'d')-
(INT(DATETIME_DIFF({Date end},{Date Start},'d')/7)+
IF(DATETIME_FORMAT({Date Start},'e')>DATETIME_FORMAT({Date end},'e'),1,0))*2, "")
),
“”)
Anyone have any idea how to write such a function that would do this correctly?
The function has to subtract from the value in the Days column the value -1 every day and ideally it should stop at 0 when it finishes basically that’s it.
