A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Excel dynamic calendar

Thread Tools Display Modes
Old December 8th 09, 05:43 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
Posts: 1
Default Excel dynamic calendar

I have created a dynamic calendar for my employees. each month is on a
seperate worksheet with a tally worksheet at the end. It is based on fiscal
year from Apr 1st to Mar 31. Any modifications are only applied on the April
worksheet (the year) which is automated on all other months, this includes
automatic changes for the days of the week, conditional formating for
highlighting weekends, vacation days, training days etc. Year is in A1, Month
in A2

I have two issues that I can't seem to resolve;

1 - on all given leap year, adding day 29 in the February worksheet. (having
the option of either adding and deleting a column, this may hinder all other
automated calculations) or (hiding and unhiding a column for that 29th day)
located in AE1

2 - Automatically adding all calculated holidays to its associated current
day and highlighting those days.

The only modifications to be done each year is changing year and "clear
Contents" on every worksheet

I am pre-begginner but have managed to write up quite a bit.



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert date from Gregorian Calendar to Hijri Calendar H.Alkhodary Excel Discussion (Misc queries) 1 February 21st 09 10:11 AM
find free sharware to include calendar pop or use calendar in cell ednc Excel Discussion (Misc queries) 2 April 14th 08 05:05 PM
how do i export excel calendar info to outlook calendar? Maggie Excel Discussion (Misc queries) 1 December 31st 07 10:27 PM
excel calendar - list of names displayed on calendar Brian'88 Excel Worksheet Functions 3 November 17th 06 10:31 PM
import calendar items from excel into outlook calendar jsewaiseh Excel Discussion (Misc queries) 0 September 2nd 05 03:53 PM

All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.