Number of days passed in quarter for a given date.

I work at a non profit where we need to track the length of stay according normal american quarters (Jan, April, July, October). We also need to do this for all data from past tenants.

We have:

-one column for a move-in date.

-One column for a move-out date.

We want:

-One column to tell us how many quarters they have lived here to date, not just what quarter the move-in date falls in.

-One column to tell us how many days they have lived here in total (we have a simple date-minus-date formula here).

-One column to tell me how many days they have have been here in this quarter.

(IMPORTANT: The most important formula that I need is one that can take a move-in date and tell me how many days someone has lived here in that quarter when that quarter is finished, and similarly a formula that can do the same for a move-out date)

Thank you all so much,

B