LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 8th 09, 06:43 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Dec 2009
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 Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Convert date from Gregorian Calendar to Hijri Calendar H.Alkhodary Excel Discussion (Misc queries) 1 February 21st 09 11: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 11:27 PM
excel calendar - list of names displayed on calendar Brian'88 Excel Worksheet Functions 3 November 17th 06 11: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 12:15 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017