• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Array calendar with Desirable Start day ?

nagovind

nagovind

Member
How to make the below array calendar to begin with Saturday or any other desired DAY ?


http://rapidshare.com/files/453180281/Array_Calendar.xls
 
Nagovind


Change the formula in D8:J13 to

Code: 
=IF(MONTH(DATE(YEAR(D6),MONTH(D6),1))<>MONTH(DATE(YEAR(D6),MONTH(D6),1)-(WEEKDAY(DATE(YEAR(D6),MONTH(D6),1))-0)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(D6),MONTH(D6),1)-(WEEKDAY(DATE(YEAR(D6),MONTH(D6),1))-0)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)

It has to be Array Entered (Ctrl Shift Enter)


Also change the formula in D7:J7 to

=TRANSPOSE({7;1;2;3;4;5;6})

It has to be array entered as well


I have put up a version where you can experiment with different starts here

http://rapidshare.com/files/453258512/Array_Calendar.xls
 
Thanks Hui

But i think it is not possible to make a Start day as Saturday using array formula..ok

it has its own limitations..
 
In the example I posted putting P2 as 0 has a week starting on Saturday.


Please clarify if that isn't what you want?
 
You must log in or register to reply here.
Back
Top