Looking to create a formula that automatically applies a 1, 0 or decimal based on the start and end date for a given month. My original formula applies a 1 or 0 and assumes either that resource started or ended a whole month. I would like this to be more dynamic calculating partial months for starting and ending months. E.g. if a person started 8/20/13 they would be assigned a 0.33 for the month of August 13' as they would be there for 10 days out of the average monthly days (365/12 = 30.4). Attachment below. Thank you for your help!
HC Formula v2.xlsx