Jump to content

calculation that shows next available date ???

This topic is 6604 days old. Please don't post here. Open a new topic instead.

Recommended Posts


How can I get a calculation to look at a table of dates and generate the next available date for something ?

An example of how I need to use this follows:

For every employee that joins the company, they need to

1. have an initial meeting with the boss

2. go to employee orientation

3. get trained on the purchasing system

Let's say the boss only meets people on the 1st and 15th of each month.

Then, Employee Orientation happens every two weeks.. (1/4, 1/18, 2/1, 2/15, 2/29...)

Purchasing System training only happens every two months (1/23, 3/23, 5/23...)

How I'd like the system to work is:

for each new employee, we'd schedule the date that the person meets with the boss,

and then the other two dates would auto-generate based on the next available date.

I'm not sure though:

1. how to get a calculation to do this.. (what is the function I should be using ?)

2. should these series of dates (boss meetings, orientation meetings, etc.) exist in their own tables ?

I guess I feel like this seems this shouldn't be difficult at all, (and I certainly don't want to overcomplicate it).. but I'm a little confused.

Any help or push in the right direction would be appreciated !!


Link to comment
Share on other sites

Hi djbeta,

thought that was an interesting question. I'm going to make a long story short by including a sample file. The "Dates" table needs to be manually filled, but you could also make a script that populates it. I have also entered the "Boss Meeting" dates, so you can use these in a pop-up list from the "Main" table to view all available dates.

I'm sure there are other ways of doing this, but this works pretty much as you've requested.cool.gif




Link to comment
Share on other sites

This topic is 6604 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.