I'm attempting to create an if statement in order to figure out some prorations. I do not think my formula is calculating the date as the date. Right now it's:
I don't think I'm trying to do anything terribly complicated - just prorate based on month, so if the date in column B is 2/1/2019, then I want 1000 prorated to equal 916.xx.
I've tried several things, but none of them have been successful.
Can someone help?