Automatic date spans in Excel
Posted on 2013-09-19
I am in need of a formula that if the current date is between the 1st and 15th of the month the date span will be the 16th through the end of the previous month. If the current date is between the 16th and the end of the month, then the date span will be the 1st to the 15th of the current month.
Thank you in advance for any help.