+ Reply to Thread
Results 1 to 8 of 8

Credit to Pete_UK Calender With Events and Holidays

  1. 01-28-2024, 02:29 PM #1
    billy60
    billy60 is offline
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    1,271

    Credit to Pete_UK Calender With Events and Holidays

    Hello,

    In appreciation for helping me I am providing a Calendar with Events and Holidays (United States) that others can use.

    I hope this helps others

    PS Credit to Pete_UK
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-28-2024, 03:19 PM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,463

    Re: Credit to Pete_UK Calender With Events and Holidays

    We don't have Grandparents Day in the UK, but your date does not agree with the comment that you have on row 27. Perhaps you have a formula which is referring to the wrong row.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 01-28-2024, 05:30 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,937

    Re: Credit to Pete_UK Calender With Events and Holidays

    It's shown as month 9 but given a date of 20 June. And the comment refers to November. Seems the date is most important.

    Neat way of getting multiple events.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 01-28-2024, 05:43 PM #4
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,463

    Re: Credit to Pete_UK Calender With Events and Holidays

    This formula is in cell P27:

    =P21+6

    I suspect it is meant to be:

    =P26+6

    based on the comment and the positioning of the entry.

    NOTE: both sheets are protected, but without a password.

    Pete
    Reply With QuoteRegister To Reply
  5. 01-28-2024, 05:53 PM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,937

    Re: Credit to Pete_UK Calender With Events and Holidays

    @Pete: there seem to be different formulae in column P.

    =IF(L4<>"",DATE(Calendar!$C$7,L4,M4),"")
    =IF(OR(OR(L5="",N5=""),O5=""),"",(DATE(Calendar!$C$7,L5,1)+(N5-1)*7)+O5-WEEKDAY(DATE(Calendar!$C$7,L5,1))+IF(O5<WEEKDAY(DATE(Calendar!$C$7,L5,1)),7,0))
    =IF(L6<>"",DATE(Calendar!$C$7,L6,M6),"")
    =IF(L7<>"",DATE(Calendar!$C$7,L7,M7),"")
    =IF(L8<>"",DATE(Calendar!$C$7,L8,M8),"")
    =IF(OR(OR(L9="",N9=""),O9=""),"",(DATE(Calendar!$C$7,L9,1)+(N9-1)*7)+O9-WEEKDAY(DATE(Calendar!$C$7,L9,1))+IF(O9<WEEKDAY(DATE(Calendar!$C$7,L9,1)),7,0))
    =IF(Calendar!$C$7,(DATE(Calendar!$C$7,L10,1)+(1-1)*7)+IF(O10<WEEKDAY(DATE(Calendar!$C$7,L10,1)),O10+7-WEEKDAY(DATE(Calendar!$C$7,L10,1)),O10-WEEKDAY(DATE(Calendar!$C$7,L10,1))),(DATE(Calendar!$C$7,L10-1,1)+(2-1)*7)+IF(O10<WEEKDAY(DATE(Calendar!$C$7,L10-1,1)),O10+7-WEEKDAY(DATE(Calendar!$C$7,L10-1,1)),O10-WEEKDAY(DATE(Calendar!$C$7,L10-1,1))))
    =IF(L11<>"",DATE(Calendar!$C$7,L11,M11),"")
    =IF(L12<>"",DATE(Calendar!$C$7,L12,M12),"")
    =IF(AND(Calendar!$C$7>1900,Calendar!$C$7<2199),ROUND(DATE(Calendar!$C$7,4,1)/7+MOD(19*MOD(Calendar!$C$7,19)-7,30)*0.14,0)*7-6,"")
    =IF(WEEKDAY(DATE(Calendar!$C$7,4,16),16)<=2,DATE(Calendar!$C$7,4,18),IF(WEEKDAY(DATE(Calendar!$C$7,4,16),1)=2,DATE(Calendar!$C$7,4,17),DATE(Calendar!$C$7,4,15)))
    =IF(L15<>"",DATE(Calendar!$C$7,L15,M15),"")
    =IF(WEEKDAY(DATE(Calendar!$C$7,L16+1,0),1)=7,DATE(Calendar!$C$7,L16+1,0)-(7-O16),(DATE(Calendar!$C$7,L16+1,0)-WEEKDAY(DATE(Calendar!$C$7,L16+1,0),1))-(7-O16))
    =IF(L17<>"",DATE(Calendar!$C$7,L17,M17),"")
    =IF(OR(OR(L18="",N18=""),O18=""),"",(DATE(Calendar!$C$7,L18,1)+(N18-1)*7)+O18-WEEKDAY(DATE(Calendar!$C$7,L18,1))+IF(O18<WEEKDAY(DATE(Calendar!$C$7,L18,1)),7,0))
    =IF(OR(OR(L19="",N19=""),O19=""),"",(DATE(Calendar!$C$7,L19,1)+(N19-1)*7)+O19-WEEKDAY(DATE(Calendar!$C$7,L19,1))+IF(O19<WEEKDAY(DATE(Calendar!$C$7,L19,1)),7,0))
    =IF(OR(OR(L20="",N20=""),O20=""),"",(DATE(Calendar!$C$7,L20,1)+(N20-1)*7)+O20-WEEKDAY(DATE(Calendar!$C$7,L20,1))+IF(O20<WEEKDAY(DATE(Calendar!$C$7,L20,1)),7,0))
    =IF(L21<>"",DATE(Calendar!$C$7,L21,M21),"")
    =IF(OR(OR(L22="",N22=""),O22=""),"",(DATE(Calendar!$C$7,L22,1)+(N22-1)*7)+O22-WEEKDAY(DATE(Calendar!$C$7,L22,1))+IF(O22<WEEKDAY(DATE(Calendar!$C$7,L22,1)),7,0))
    =IF(L23<>"",DATE(Calendar!$C$7,L23,M23),"")
    =IF(L24<>"",DATE(Calendar!$C$7,L24,M24),"")
    =IF(L25<>"",DATE(Calendar!$C$7,L25,M25),"")
    =IF(OR(OR(L26="",N26=""),O26=""),"",(DATE(Calendar!$C$7,L26,1)+(N26-1)*7)+O26-WEEKDAY(DATE(Calendar!$C$7,L26,1))+IF(O26<WEEKDAY(DATE(Calendar!$C$7,L26,1)),7,0))
    =P21+6
    =IF(L28<>"",DATE(Calendar!$C$7,L28,M28),"")
    =IF(L29<>"",DATE(Calendar!$C$7,L29,M29),"")
    =IF(OR(OR(L30="",N30=""),O30=""),"",(DATE(Calendar!$C$7,L30,1)+(N30-1)*7)+O30-WEEKDAY(DATE(Calendar!$C$7,L30,1))+IF(O30<WEEKDAY(DATE(Calendar!$C$7,L30,1)),7,0))
    =IF(L31<>"",DATE(Calendar!$C$7,L31,M31),"")
    =IF(L32<>"",DATE(Calendar!$C$7,L32,M32),"")
    =IF(Calendar!$C$7,(DATE(Calendar!$C$7,L33,1)+(-1)*7)+IF(O33<WEEKDAY(DATE(Calendar!$C$7,L33,1)),O33+7-WEEKDAY(DATE(Calendar!$C$7,L33,1)),O33-WEEKDAY(DATE(Calendar!$C$7,L33,1))),(DATE(Calendar!$C$7,L33,1)+(1-1)*7)+IF(O33<WEEKDAY(DATE(Calendar!$C$7,L33,1)),O33+7-WEEKDAY(DATE(Calendar!$C$7,L33,1)),O33-WEEKDAY(DATE(Calendar!$C$7,L33,1))))
    =IF(L34<>"",DATE(Calendar!$C$7,L34,M34),"")
    =IF(L35<>"",DATE(Calendar!$C$7,L35,M35),"")
    =IF(OR(OR(L36="",N36=""),O36=""),"",(DATE(Calendar!$C$7,L36,1)+(N36-1)*7)+O36-WEEKDAY(DATE(Calendar!$C$7,L36,1))+IF(O36<WEEKDAY(DATE(Calendar!$C$7,L36,1)),7,0))
    =IF(L37<>"",DATE(Calendar!$C$7,L37,M37),"")
    =IF(L38<>"",DATE(Calendar!$C$7,L38,M38),"")
    =IF(L39<>"",DATE(Calendar!$C$7,L39,M39),"")
    Reply With QuoteRegister To Reply
  6. 01-28-2024, 06:06 PM #6
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,463

    Re: Credit to Pete_UK Calender With Events and Holidays

    Yes, I know, Trevor, but when you have things like "first Wednesday in Spring" (joking !!) you have to calculate it differently than the other entries.

    That's why I felt that the comment about Grandparents Day was significant in this case.

    Pete
    Reply With QuoteRegister To Reply
  7. 01-28-2024, 06:10 PM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,937

    Re: Credit to Pete_UK Calender With Events and Holidays

    That's why I felt that the comment about Grandparents Day was significant in this case.
    Fair enough
    Reply With QuoteRegister To Reply
  8. 01-28-2024, 07:39 PM #8
    billy60
    billy60 is offline
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    1,271

    Re: Credit to Pete_UK Calender With Events and Holidays

    I believe the formulas are correct but thanks guys for checking.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a calender that automatically lists which events need to happen on each day
    By tiger0485 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2016, 01:15 PM
  2. [SOLVED] Display "events" on certain dates, e.g. holidays, downtimes, sick leave
    By eyestorm in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-24-2014, 08:57 AM
  3. Create events in Outlook Calender from Excel without duplicates
    By Southernw2002 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2014, 02:23 PM
  4. Import Excel Calender into outlook calender appointments
    By cartica in forum Excel General
    Replies: 8
    Last Post: 01-28-2014, 11:02 AM
  5. Want to make a Calender with Dropdown List Events(picture) for each Day
    By pietersc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2012, 02:13 PM
  6. Creating a Calender using events from an excel sheet
    By mmv123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2011, 11:45 AM
  7. How to Generate a calender of Events from data/ Pivot Table
    By MillieDileo in forum Excel General
    Replies: 0
    Last Post: 05-10-2006, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1