Forum Discussion

SheriCory's avatar
SheriCory
Copper Contributor
Sep 28, 2022

XCEL

How do I create a formula using dates.  I have a date in G6 of 9/27 and in H6 it needs to be 145 days after 9/27. Then I need to copy that formula down so it populates in all H cells. 
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Sep 28, 2022

SheriCory Use SEQUENCE() function. Sequence function will spill result automatically. So, you no need to drag the formula manually.

=SEQUENCE(145,,G6)
  • SheriCory's avatar
    SheriCory
    Copper Contributor
    Sep 28, 2022
    Oops I couldnt get that to work.
    • Harun24HR's avatar
      Harun24HR
      Bronze Contributor
      Sep 28, 2022
      Then may be you do not have sequence function. Sequence is only available to Excel-365.
      • SheriCory's avatar
        SheriCory
        Copper Contributor
        Sep 28, 2022
        ok thanks

Resources