steph74

I didn't understand if newshift was a global variable or not. If it's a local one, you can just pass it to the function calles as a parameter .

I think you have to calculate the day of the year from the current date. To do that, your have to write a function that gives the number of days for each month of the year regarding the bissextile years. Then write a function to determine which day of the year is the first day of the month based on the preceding one.Finally, calculate the day of the year regarding the difference between the day of the month and the first day of the month.

To define how to pass parameters, juste write byRef or byVal before the parameter name in the function header. The default mode is byRef