ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   dates (https://www.excelbanter.com/excel-programming/303864-dates.html)

Easynews

dates
 
I would like some help on a small project.

I would like the user to enter 12 dates. Each pair of dates defines the
beginning and the end of a period. There are obviously six periods.

The difficult bit is this. I would like Excel to generate all the dates of
the 6 periods. They have to be next to each other AND with weekdays only.

I know I can do this with Fill, but I would like to automated it. Thank you
in advance.




All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com