• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

To tabulate a Date automatically in Excel for Master Reboot Frequency for a Year

H

hafizah5983

New Member
hi,


currently i need to manually copy the formula to tabulate a Date in Master Reboot Frequency. But it's will be a problem when changing a year and some month will have 5 week or 4 week in a month. So i need to do manually clean up. In this schedule, they have some rules example Frequency in Quarterly : Last Saturday (Feb, May, Aug, Nov,Bi-Monthly : 2nd Sunday(Jan,Mar,May,Jul,Sep,Nov), Weekly Restart Except 3rd Sunday(Mar,Jun,Sep,Dec) and etc


:-currently i'm using this formula to determine a Last Sunday =INT((EOMONTH(DATE(YEAR,Month,0),1)-1)/7)*7


:-The challenging is when some week changing for 4 week in month to 5 wee so the last Sunday or Saturday maybe need to do some checking for my schedule to make sure the date are correct. also when i have a new server register, so i need to do manually copy the formula to tabulate a date based on rules that tagging to that server reboot procedure.


hope someone could help me to solved my problem.
 
H Hafizah,


Can you post some sample data or a sample file for your problem, it is will be easier to solve it. Kindly also elaborate referring to the sheet/data that you upload.


Regards,
 
Hi Hafizah ,


Can you clarify two points ?


1. In your worksheet , you have the following frequencies :

[pre]
Code: 
Weekly Restart               Every Sunday
Weekly Restart               Except 3rd Sunday (Mar,Jun,Sep,Dec)
Monthly                      2nd Monday
Bi-Monthly                   Last Friday (Jan,Mar,May,Jul,Sep,Nov)
Quarterly                    Last Sunday (Jan,Apr,Jul,Oct)
Quarterly                    Last Sunday (Mar ,Jun ,Sep , Dec)"
[/pre]
Will these be the only frequencies ?


2. Are the formulae which you have at present correct , at least in some region(s) ? Then , we can use these formulae to understand what your problem is.


Narayan
 
You must log in or register to reply here.
Back
Top