Forum Discussion

KatieGriffiths's avatar
KatieGriffiths
Qrew Trainee
8 years ago

Formula Support-Duration # of days in a month

Not sure if I can ask a question from here again? I had help with the original formula-and it is about the same formula(s)

I have the formula:
Sum([BTC Discharge Date]-[BTC Admission Date]) 

and now I need to know how many of those days fall in each month.

I also have a simple duration report that I can pull from

Min(Today(),[BTC Discharge Date]) -[BTC Admission Date] 

What is the best way to calculate the days that occurred in a month?

Thanks in advance for the help.
Katie
Ask about Quickbase functionality
Formulas and functions

22 Replies

Sort By
Show More
  • KatieGriffiths's avatar
    KatieGriffiths
    Qrew Trainee
    8 years ago
    Awww thanks-I really appreciate that-but know I will do my best to learn and try first..and only then will I call uncle...
    That being said-I feel for you, watching a family member change is a roller coaster ride of good and bad...Just saying-from anywhere in the world if you ever want some "dementia" support/counsel reach out and we can communicate outside of the forum- sometimes you just need to brain storm dementia communication like I do formula stuff!!!
    Thanks again...