Re: re calendar to 12 month calendar

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steved (sjdee_at_clear.net.nz)
Date: 07/04/04 

Date: Sun, 4 Jul 2004 13:08:10 +1200

Hello Daniel
Sorry I was using
=IF(MONTH(A2-DAY(A2)+1-WEEKDAY(A2-DAY(A2)+1)+Mtx)=MONTH(A2),A2-DAY(A2)+1-WEEKDAY(A2-DAY(A2)+1)+Mtx,"")

I am now using =IF(MONTH(DATE($A$1,A2,1)-WEEKDAY(DATE($A$1,A2,1))+Mtx)=A2,
DATE($A$1,A2,1)-WEEKDAY(DATE($A$1,A2,1))+Mtx,"")
Ok A1 I have formated as ("yyyy"), A2 as ("m") and entered as array formula
contrl shift enter,
I am getting #NUM!
The days are row wise ie Sun to Sat is this my problem

"Daniel.M" <prenom.maher@bigfoot.inutil.com> wrote in message
news:%23QhWhyVYEHA.1000@TK2MSFTNGP12.phx.gbl...
> What???!!!
>
> I (re)gave you on my previous message a formula to construct a 6 by 7 grid
> for
> ONE MONTH when you know the year (in A1) and the month number (in A2,
> 1-12).
>
 =IF(MONTH(DATE($A$1,A2,1)-WEEKDAY(DATE($A$1,A2,1))+Mtx)=A2,
DATE($A$1,A2,1)-WEEKDAY(DATE($A$1,A2,1))+Mtx,"")
>
> It assumes the year is in A1 and the month number is in A2. Have you used
> it? Do
> you understand that depending on the number (1 to 12) in A2, the grid will
> show
> the proper month.
>
> Now, you want ALL the months of a given year displayed.
> So you'll have to put 12 grids of the formula but changing the A2 part to
> have
> the numbers 1 to 12 instead. Then, you'll get all the months of year A1 in
> 12
> grids (6 by 7 each).
>
> Regards,
>
> Daniel M.
>
>

Quantcast