Date Intervals

C

CouchPotato

Hi guys, I'll make it real quick.

I want to add a 4 days interval between dates after 4 consecutive day
(regardless weekends), similar to roster/shift ie:
A1 to D1 = 1-Jan, 2-Jan, 3-Jan, 4-Jan
E1 to H1 = 9-Jan, 10-Jan, 11-Jan, 12-Jan
I1 to L1 = 16-Jan and so on....

Is there an Einstein way how to formulate this format? Thanks heap
guys
 
V

Vacuum Sealed

Hi guys, I'll make it real quick.

I want to add a 4 days interval between dates after 4 consecutive days
(regardless weekends), similar to roster/shift ie:
A1 to D1 = 1-Jan, 2-Jan, 3-Jan, 4-Jan
E1 to H1 = 9-Jan, 10-Jan, 11-Jan, 12-Jan
I1 to L1 = 16-Jan and so on....

Is there an Einstein way how to formulate this format? Thanks heaps
guys.
Hi

This is not pretty:, but it will get you what you need

Custom format row A:A as d-Mmm.

In Cell A1 put the date 1-Jan
In Cell B1 put formula =(A1+1)
Copy/Paste across to C1:D1.

In Cell E1 put formula =(D1+5)
In Cell F1 put formula =(E1+1)
Copy/Paste across to G1:H1

Then

Select E1:H1 and copy/paste across row one until you have your desired
amount of days.

HTH
Mick
 

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

Top