Date series calculations
We publish 22 issues of a paper a year, publishing only a Jan 15 and a July 1 and on the 1st and 15th of every other month. I want a calculation that could
- know today's date
- increase the issue number by 1
- change the day to "1" or "15"
- change the year every jan 15
I'm having no luck whatsoever even getting started on this since dates throw me for a complete loop.
I have Issue_number, and Issue_date. I suspect it's easier to work with numbers and convert them to a specific date to do this, but nothing has worked for me.
Any help gratefully accepted.
macintel - fmp 11.x