Re Date

[Steved]

Hello from Steved

I would like to build a Calendar, in this case 1st April.

G2 will have Sun, H2 will have Mon, I2 will have Tue,
J2 will have Wed, K2 will have Thu, L2 will have Fri
and M2 will have Sat. I need to put a formula in
G1,H1,I1,J1,K1,L2 and M2 so in this case the 1st April is
on Thu so it needs to know that cell K2 is Thu therefore
it will input 1-Apr, If you can get me started I will then
build this calendar and the following 11 months. I just
need this formula to understand the princible behind
building Calendars in Excel Spreadsheets.
Thankyou.

 

[Frank Kabel]

Hi
have a look at
http://j-walk.com/ss/excel/files/calarray.exe

 

[Steved]

Thankyou thankyou.

This is the formula That I wanted.

Cheers