VBA IF date is first week of month then add 4 days on

[Nikijune]

Hello,

I am trying to automate a report request form, which currently automatically provides a completion date depending on the severity of the report, however, what I would like it to do now is add 4 days onto that date if the date is within the first 7 days of the month. This is because the first week of the month is the busiest time for us and we do not have capacity to complete additional requests in this time.

My current formula looks at what todays date is, and then adds on however many days. It is this date that I want to add 4 more working days onto.

I am not sure if this will be VBA or just a simple formula. Any ideas??

Thanks

 

[Snakehips]

Nikijune,

Try replace your 'Current Formula' with...

=IF(DAY(Current Formula)>7,Current Formula,Current Formula+4)

Hope that helps.

 

[Nikijune]

Thanks for your help Snakehips, much simpler than what I was trying for

It's not working quite how I need it to as it is now giving me weekend dates.

This is what it is looking like;

=IF(DAY(WORKDAY(C16,C15))>7,WORKDAY(C16,C15),WORKDAY(C16,C15)+4)

The date in C16 is todays date and C15 contains the number of days to add on to todays date depending on the severity.

The workday(C16,C15) part of the formula works ok, but the new part to add 4 extra days on if it is within the first week is showing weekend dates. Any ideas?

Thank You

 

[Snakehips]

Does =IF(DAY(WORKDAY(C16,C15))>7,WORKDAY(C16,C15),WORKDAY(C16,C15+4)) do it ?

It can still generate a fresh date that is within the first week of following month but it will be extended by 4 workdays beyond the original.

 

[Nikijune]

Thanks so much - works a treat