# Provide every other Tuesday based on odd or even week number of year

1. ## Provide every other Tuesday based on odd or even week number of year

I want to create a formula that provides me with a date of every other Tuesday based on whether the week number in the year is an odd week or an even week.

2. ## Re: Provide every other Tuesday based on odd or even week number of year

not exactly sure what kind of data you're working with, but maybe something along the lines of

=IF(AND(ISEVEN(WEEKNUM('date ref')),WEEKDAY('date ref',2)=2),'date',"") for even tuesdays,
or: =IF(AND(ISEVEN(WEEKNUM('date ref')),WEEKDAY('date ref',2)=2),"",'date') for odd tuesdays ?

Hope that helps

Perfect!!

4. ## Re: Provide every other Tuesday based on odd or even week number of year

Glad it works for you !

##### Users Browsing this Thread

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

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1