I'm trying to create an excel sheet to add a certain number of days to the current date and return that value. The problem is however that I want it to only count business days (excluding weekends and public holidays).
To start, I created 4 columns.
Column A contains all the days in the yearn in excel date format from A1 - A365
Column B contains the days of the week from B1 - B365
Column C contains a a simple yes or no depending on whether that day is a business day or not.
I know that to add normal days I type "=today() + x", x being the number of days to add.
I imagine I will need to create a variable which increments everytime it encounters a yes and then when the variable is equal to x, it must print that date.
I am just very lost at present.
How do I make it check through every date and its attached yes or no value and increment a variablel; and then print the current date when it reaches a certain number?
Or am I approaching this incorrectly?
Any assistance will be greatly appreciated.
Thanks
To start, I created 4 columns.
Column A contains all the days in the yearn in excel date format from A1 - A365
Column B contains the days of the week from B1 - B365
Column C contains a a simple yes or no depending on whether that day is a business day or not.
I know that to add normal days I type "=today() + x", x being the number of days to add.
I imagine I will need to create a variable which increments everytime it encounters a yes and then when the variable is equal to x, it must print that date.
I am just very lost at present.
How do I make it check through every date and its attached yes or no value and increment a variablel; and then print the current date when it reaches a certain number?
Or am I approaching this incorrectly?
Any assistance will be greatly appreciated.
Thanks
