CouchPotato CouchPotato is offline

Junior Member

Posts: 2

Date Intervals

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel date intervals look up	adam smith	Excel Worksheet Functions	1	January 29th 10 10:53 AM
date intervals calculation	martyn	Excel Worksheet Functions	9	February 6th 08 01:30 PM
SUM-ing date for different time intervals	Mortir	Excel Worksheet Functions	3	December 11th 06 06:26 PM
date intervals	jer	Excel Worksheet Functions	3	January 13th 06 04:22 PM
calculating date intervals	jer	Excel Worksheet Functions	0	January 13th 06 12:12 PM

All times are GMT +1. The time now is 02:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us