Help! ISO formula for inconsistent monthly dates
What a goofy subject, I know. For my monthly budget, I want to output the
date in every column, two weeks apart. These represent paydays. However,
paydays are on the 15th and the last weekday of every month.
(For example: 8/31, 9/15, 9/29, 10/15, 10/31...)
Obviously, these dates won't all be 14 days apart. Is there any way to tell
Excel to output the date in the above manner?
|