Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-25-2013, 07:58 AM
ArviL ArviL is offline calender formula Windows 7 64bit calender formula Office 2007
Novice
 
Join Date: Feb 2013
Posts: 11
ArviL is on a distinguished road
Default

Hi

I assume you use US weekday counting, i.e. Sunday is the 1st day of the week?
When this is the case, then:
1. Add an additional row to your calendary so you don't lose some month's endings;
2. Extend your months list in column O (and fill all gaps in it, so you have all months from January to December listed (Range O2:O13);
3. Copy this formula into leftmost upper cell of your calendary (D9):
=IF(MONTH(DATE($L$12,MATCH($L$9,$O$2:$O$13,0),1)-(WEEKDAY(DATE($L$12,MATCH($L$9,$O$2:$O$13,0),1))+0 ) + (COLUMN()-COLUMN($C:$C))+7*(ROW()-ROW($9:$9)))=MATCH($L$9,$O$2:$O$13,0),DATE($L$12,M ATCH($L$9,$O$2:$O$13,0),1)-(WEEKDAY(DATE($L$12,MATCH($L$9,$O$2:$O$13,0),1))+0 ) + (COLUMN()-COLUMN($C:$C))+7*(ROW()-ROW($9:$9)),"")

(Check the formula for semicolons instaed of comma for case I missed some replacements there!)
4. Copy the formula in D9 into entire calendary table (D9:J14). Format calendary cells as custom "d".
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
calender formula Unable to sync iphone calender with outlook calender!! Reltub Outlook 5 07-26-2011 02:55 AM
Hijri Calender zuzu_cool Outlook 0 07-15-2011 11:04 PM
Calender reminders msb Outlook 0 01-31-2008 01:40 PM
Problem i'm having with my calender Flawliss Outlook 1 01-18-2007 05:16 PM
daily calender printing ccronin4 Outlook 1 01-10-2007 12:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft