dates by ranges

Hello, I have a few challenges that I need your help with. I have a daily sales log which i have to convert to provide data in three different formats: 1) weekly - sum 7 consecutive days from a starting date; 2) weekly - starting 1st of each month and up to including Sunday of that week. The...

I have created a Gantt Chart within Excel that has 30 tasks. The date is shown on the top horizontal axis but in addition I would like the start/end dates to show before and at the end of each task. Is there any way to create this?

Hello. I have this spreadsheet: How can I make it so that, for whatever number I put in B1 it takes the date in A4 and automatically fills in rows below by increasing the months. So, for example, if I put 3 in B1 I want it to automatically look like this: How can I do this? Is it a...

Hello, I am here because after an exhaustive search of the internet, I simply cannot find a solution to an Excel problem I have. Here's the situation. I have my own accounting spreadsheet that I have created myself. I have separate sheets for a lot of things, but two of them are income and...

Hi there, I work for a Wedding Suit Hire company. I need to create a list in excel to check what Wedding Suit parties need to be packed for that week. What I want to happen is this: Every Sunday morning I print out a list of the wedding parties that need to be packed that week. I want this...

I've used the NETWORKDAYS to count my calendar span (beg/end) including setting up a holiday table. Within this calendar span there are 6 cycle periods and I've used NETWORKDAYS to calculate the day counts per each cycle. The per cycles days counts total to the span total. The next step issue...