• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

Calculation for date to be 1 month out

Greetings Experts,

Here is the scenario.  I will need to calculate a date that is 30 days (1 month) from a date entered in a cell.  The trick is that if the date falls on a non-working day it must roll to the next working day.

Thanks in advance.
0
Vendettta
Asked:
Vendettta
1 Solution
 
barry houdiniCommented:
If you want exactly 1 calendar month later then with date in A1 use this formula in B1

=WORKDAY(EDATE(A1,1)-1,1)

That will not fall on a Sat or Sun, if you want to avoid holidays too then with holidays listed in H2:H10 try this version

=WORKDAY(EDATE(A1,1)-1,1,H$2:H$10)

That adds a month then jumps to the next workday (if necessary)

or you can use just 30 days like this

=WORKDAY(A1+30-1,1)

regards, barry
0
 
VendetttaAuthor Commented:
Barryhoudini! Your answers are always the best!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now