Hello. I've hit a snag and need to be able to create an effect similar to an if while loop without using vba. (computers at my work just delete any vba code unless I was to sit at each computer and build it for a user personally). I know I can easily do this with an If While loop but that isn't an option.
Example of what I am trying to do:
30 Days(variable # entered by user)
9/14/ 2014 Date 1 (variable entered by user)
11/3/2015 Date 2 (variable entered by user)
From date 1 it uses the day variable date until it reaches the one before date 2.
So in the above example it would go to 10/14/2014, 11/13/2014, 12/13/2014 and continue on til it reached 10/9/2015 (because 30 days after that would be 11/8/2015 which is past my date 2 variable)
I don't need any of the inbetween dates, it would just need 10/9/2015 in this example.
Is this possible to do without VBA code?
Example of what I am trying to do:
30 Days(variable # entered by user)
9/14/ 2014 Date 1 (variable entered by user)
11/3/2015 Date 2 (variable entered by user)
From date 1 it uses the day variable date until it reaches the one before date 2.
So in the above example it would go to 10/14/2014, 11/13/2014, 12/13/2014 and continue on til it reached 10/9/2015 (because 30 days after that would be 11/8/2015 which is past my date 2 variable)
I don't need any of the inbetween dates, it would just need 10/9/2015 in this example.
Is this possible to do without VBA code?
