Custom Field Creation (no. of days)

Custom Field Creation (no. of days)

Hi there,

I would like to know if I can have a custom field created using formula or some function. The expectation of this field will be the number of Calendar (weekday) days calculating from a Date field.

For example - there is a Date Field in the Record wherein we will put a date (01.06.2024), now when this date is entered, in the custom field that we need should have the number of calendar days between 01.06.2024 and today (12.06.2024) would be 9.

Since, there are 9 calendar days including today between 01.06.2024 and today 12.06.2024.

So, I wanted to ask if its possible to have such field created which can give us the number of days and gets updated every date when date changes.

Thanks,