ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Setting up a bi-weekly calendar event (https://www.excelbanter.com/excel-discussion-misc-queries/262862-setting-up-bi-weekly-calendar-event.html)

calendar help

Setting up a bi-weekly calendar event
 
I am trying to create a 12 month calendar at work to post a class that is
given every other Friday. Is there a way to formulate this without tying
each class in individually.

Sean Timmons

Setting up a bi-weekly calendar event
 
Not sure how you have built your calendar....

Just need to display where the day is equal to the value or the value plus a
multiple of 14 (MOD(14)=0 would help here), but ned more info to help any
further...

"calendar help" wrote:

I am trying to create a 12 month calendar at work to post a class that is
given every other Friday. Is there a way to formulate this without tying
each class in individually.


Luke M[_4_]

Setting up a bi-weekly calendar event
 
Is this an Outlook question, or XL?

Outlook will let you set a recurence of weekly, every two weeks.
For XL, give a start date, then ahve the next date be:
=A2+14

--
Best Regards,

Luke M
"calendar help" <calendar wrote in message
...
I am trying to create a 12 month calendar at work to post a class that is
given every other Friday. Is there a way to formulate this without tying
each class in individually.





All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com