# Macro to run if workday date is after the 7th of every month

1. ## Macro to run if workday date is after the 7th of every month

On my sheet "Test" I have workday formulas in cells C6 and C7. I am trying to reference these dates in those cells so if the date is after the 7th of any month, it runs the rest of the IF statement. What I have below recognizes any date as after the 7th.

2. ## Re: Macro to run if workday date is after the 7th of every month

What do these formulas look like ("workday formulas in C6 and C7 cells") ?

3. ## Re: Macro to run if workday date is after the 7th of every month

Hiya, try this out...

4. ## Re: Macro to run if workday date is after the 7th of every month

Skip first six days?

5. ## Re: Macro to run if workday date is after the 7th of every month

=WORKDAY(D6,E6) which returns the date 12/31/18
=WORKDAY(D7,E7) which returns the date 1/1/2019

6. ## Re: Macro to run if workday date is after the 7th of every month

Poizhan: That works, thanks!

Thank you both for your help!

7. ## Re: Macro to run if workday date is after the 7th of every month

You're welcome, have a good day

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