Thank you for your help. I was hoping to have just one column for the total instead of 3 for each period I am calculating. I found a similar formula on another spreadsheet but when I tried to copy it but using my information, I kept getting a popup saying my formula was too long.
This is the formula I was trying to use: =G195*DAYS(DATE(2019,10,31),DATE(2017,11,1)) Thanks again for your help.