what can i use instead of the new SEQUENCE function to generate dates? my users specify the frequency that they receive income and then input the first receipt date. All good for weekly and fortnightly; just add 7 or 14 to the specified date. Monthly is causing me grief. i can use an index match formula to pick up the frequency specified by the user and find the number of days to add to the specified date for weekly or fortnightly but how to do monthly??? any suggestions would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
use sequence in older versions of excel
- Thread starter ajm
- Start date
Excel Facts
What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Similar threads
- Replies
- 0
- Views
- 243
- Replies
- 7
- Views
- 448
- Replies
- 0
- Views
- 693
- Replies
- 2
- Views
- 528
