Forum Discussion

charitos89's avatar
charitos89
Copper Contributor
Nov 19, 2021

Alternative for SEQUENCE function on EXCEL 2019

Hello.   I am using the Excel 2019 and i want to create a sequence of dates number that depends on a selected month of a year from a data validation list (screenshot). I can do that on Excel 365 (w...
office 365
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Nov 19, 2021

charitos89 

SEQUENCE function

Note: This function is currently available to Microsoft 365 subscribers in Current Channel. It will be available to Microsoft 365 subscribers in Semi-Annual Enterprise Channel starting in July 2020.

For more information on how features are rolled out to Microsoft 365 subscribers, see When do I get the newest features for Microsoft 365.

 

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

  • charitos89's avatar
    charitos89
    Copper Contributor
    Nov 19, 2021
    I already knew that NikolinoDE. I am searching for the alternative of SEQUENCE function.
    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Nov 19, 2021

      charitos89 

      You are absolutely right, sometimes thoughts fly faster than the eye can read :).

      In my hurry, I did not read the entire text.

      Here is some information from the Internet for alternatives to dynamic formulas.

      ALTERNATIVES

       

      Thank you for your understanding and patience

      I think Mr. Lewin gave the answer you probably need.

      Thanks to Mr. Lewin 🙂

Resources