Custom 4 week periods

D

dazza_dog

I have the need to calculate 4 weekly periods with the periods starting on a
Thursday (historical reasoning) as follows:
Period 1 Start-29th May End-25th June
Period 2 Start-26th June End-23rd July

I have found out how to do this with Access but the same functions are not
available in Excel

Many thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Pay Periods 4
calculating number of three month periods between two dates... 3
Storing data by week 1
Make the query work out the date inputs automatically? 2
how do I query daily records by week? 1
recognizing dates past End of Month 6
working out quarters (three-month periods) between two dates 1
Date Issue for viewiing 1

Top