How to Add Days to Dates in Excel

Sdílet
Vložit
  • čas přidán 5. 08. 2024
  • In this video we look at 2 easy ways to add or subtract days to dates in Excel using formulas and copy & paste.
    Please leave a comment below with any techniques you use to add days to dates. There are a lot of ways to go about this.
    Software Tools/Products by Teknisha:
    🔷 gumroad.com/teknisha🔷
    Recommended Gadgets/Products:
    www.amazon.in/shop/teknisha
    Must Watch Playlists..
    Excel Tutorials:
    • TEKcel Series : Excel ...
    Excel Chart Tutorials:
    • TEKcel Chart Tutorials...
    Excel Pivot Table Tutorials:
    • Excel Complete Pivot T...
    Excel Gsuite Tutorials:
    • Gsuite Tutorials
    Excel Tips & Tricks:
    • TEKcel Tips : Excel Ti...
    Powerpoint Tutorials:
    • Tekpoint Series : Powe...
    App Reviews: • Apps
    Gadget Reviews:
    • Gadget Reviews
    Thanks for watching!!! 😊🙏
    Please do Subscribe and Hit the Bell 🔔icon to receive all my videos Notifications.
    CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/TeknishaSubscribe
    Follow me on below to stay connected👇
    👉FaceBook: / teknisha
    👉Instagram: / teknisha_
  • Jak na to + styl

Komentáře • 8

  • @cagsalem4194
    @cagsalem4194 Před 2 lety

    help me by entering any date during the month in one cell and showing the final date of that month in another cell. What function used

  • @sharran9
    @sharran9 Před rokem

    Thanks in same way for eg i want to add say 38 or 40 days but i want that the result should be only Monday dates shown after adding no of days

  • @m7mmd244
    @m7mmd244 Před 3 měsíci +1

    Hello, i’ve watched your tutorials and would like to thank you very much for your efforts, that was very helpful.
    I have a challenge in excel “dynamic conditional formatting” and i am seeking your support to find a solution for it.
    Assuming that i created a calendar in excel “dynamic calendar” where i can change the year in a drop-list and everything below will be updated according to the year in that specific cell.
    The question is, how can i create a dynamic conditional formatting for a specific dates that will be highlighted regardless the year value ??
    Hence:
    For example, date 10th of October
    [[ =Date( year(today()) , 10 , 10 ) ]] is not working very well ..

    • @TEKNISHA
      @TEKNISHA  Před 3 měsíci

      Happy to Help!! You can add a List of dates you want to conditional format in a separate column and then check for all dates in your dynamic calendar against that list. This way you can highlight multiple dates.

  • @facelessgamer2.073
    @facelessgamer2.073 Před 2 lety

    What is the name of the font which you use in your thumbnails....please tell me😟

  • @sheebs8656
    @sheebs8656 Před rokem

    Yeh...you are still making videos!

  • @user-ye9wh4oz1z
    @user-ye9wh4oz1z Před rokem

    WHAT IF THE YEAR CHAGES

  • @liamiegelacio8356
    @liamiegelacio8356 Před 3 měsíci

    its not applicable to my microsoft