I need a calculation for the number of dates between a certain date and the end of that year. For example, if column A has the date that someone became a member of the program, I want column B to state how many months are between that and December.
Currently I am using this...
There is likely a simple way to do the formatting that I want, but- I certainly don't know how. I'm open to any suggestions.
Here's my goal:
I would like a column for prorated dues in 2013. Not everyone on the spread sheet owes prorated dues, so here is my idea that needs to be translated...