Aysher Ryan
New Member
I utilized this equation to figure how long a customer was living in an office since the start of the month, marking down 2 days that this individual was out and no discharge date accessible.
=IF(ISBLANK(D2),TODAY()- C2,D2-C2)- E2
I need to do is add to this equation the accompanying condition: Use the affirmation date as the start of the month if the confirmation date is later than the start of the month.
1st. Day/Month (A)Name (B)Admission Date (C)Release Date (D)# Of days out (E)# of Days Since Beginning of the Month (F)# of Days In Since Admission. (G)
08/01/18AAA08/10/1834
08/01/18CCC07/01/182738
=IF(ISBLANK(D2),TODAY()- C2,D2-C2)- E2
I need to do is add to this equation the accompanying condition: Use the affirmation date as the start of the month if the confirmation date is later than the start of the month.
1st. Day/Month (A)Name (B)Admission Date (C)Release Date (D)# Of days out (E)# of Days Since Beginning of the Month (F)# of Days In Since Admission. (G)
08/01/18AAA08/10/1834
08/01/18CCC07/01/182738