Hello everyone, here is what I have to do. In my data file I have a client's date of birth and other several date columns: Client DOB, Client Intake, Client Start and Client Referral Date. I want to be able to write a formula that will sum the date difference between each of the date columns and Client DOB by condition and put that information into tables. For example, I want to sum groups of "date diff" between client DOB and Client Intake by age categories by month:
16-19 months
20-25 months
26-30 months
and so on.
I am hoping I can do each with one formula - realizing it will be a long formula for each of the Date columns and Client DOB.
Thank you for your help.
Zeda
Bookmarks