I think it's working now. Thanks for that!! So basically, the date field has to be kept in the detail in order for these calculated fields to work.
Is there any other alternative too without having to put the date field into detail? Just curious to learn about other alternatives too.
There might be, but from the first look, your view already contains some sort of complication and I hesitated to try another option because that might require ton of setting / formula change.
BTW, if this helped, please mark my answer as correct / helped to close the thread, not from inbox but from original post.
Ok, thanks for the help though!
Marked it too