Excel Magic Trick 783: Date Functions & Formulas (17 Examples)



Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. DAY function 2. TEXT Function to get Day spelled out, like "Monday" 3. TEXT Function to get Month spelled out, like "January" 4. MONTH Function 5. YEAR function 6. Last Day in Month: EOMONTH function 7. Last Day in Month: DATE, YEAR, DAY, MONTH functions 8. First Day Next Month: EOMONTH function 9. First Day Next Month: DATE, YEAR, DAY, MONTH Functions 10. Vest Date: EDATE function 11. List of First Day in Month: EOMONTH 12. WORKDAY function -- find workday in future given a certain number of days. 13. WEEKDAY function 14. Last Monday: DATE, YEAR, MONTH, DAY and WEEKDAY functions 15. Formula for Days Between Two Dates 16. Formula for Days Between Two Dates, Inclusive 17. Net Working Days with NETWORKINGDAYS Function Buy excelisfun products: https://teespring.com/stores/excelisfun-store

Comments

  1. Very Helpful Thank you
  2. Excal me date filter karna h date filter ka option nahi aad raha
  3. Hello!
    I have been looking for a formula, array, vba code to get me a column with the dates for 2019 excluding weekends and holidays. Ive been trying to set up a timeline like calendar and was able to figure out the network days function; however, it didn't include day 31....not sure how to fix this. Any help with this is appreciated. not sure how to attach a sample on here.
  4. Is there a formula for autofilling month and year only? i.e. if I enter 12 and hit return, it autofills 12-Jan-18.
  5. Thank you very much. I got very useful help
  6. year is also changing using of this format 01.01.2018
  7. Love it! Watched the entire video! Do you have one that shows you how to create a formula if you have multiple columns of dates (for certifications) that expire that will change a cell (even if in a separate column) to True/False based upon the current date?
  8. @EXCELLSFUN WHAT FORMULA DO USE IF I WANT THE NEXT COLUMN TO AUTOMATICALLY WRITE IN (YYYY+2. MM+0. DD-1) . FOR EXAMPLE: C1 = 2018-10-21 AND I WANT D1 TO AUTOMATICALLY SAY D1= 2020-10-20 ? CAN YOU HELP ME TO FIND A FORMULA FOR THAT?
  9. Month in text - exactly what I needed. Simple but I wouldn't have been able to think about it myself. Thanks, Nicole from Canada
  10. WOW! Read my mind in exactly what I needed. Thanks.
  11. thank you
  12. Excuse me
    If I want to apply tomorrow date or after ....
    Without accept today date
    How it is ????
  13. I had a question. How could I keep the same month and the same year but just have to input the date? such as if the dates I am working with is 6/18 for June 2018, I just want to be able to put 23 in the cell so when I press "enter" it will say "23-June-18" is that possible?
  14. Thank you so much
  15. Mike, If you've explained this already I apologize. I have 2 columns of dates (from and to dates) that I want to combine into one date range column. Using this formula (=TEXT(H2," mmm d, yyyy")&" - "&TEXT(I2,"mmm d, yyyy"))works fine in most cases but sometimes only part of the date was known so it was written as text or possibly left blank, of course this is where it fails. I've been experimenting but haven't been able to work something out that addresses all scenarios. In the sample below, the 1st and 2nd line work ok but the rest do not. Help please, I have to come up with something to implement on thousands of lines in multiple workbooks so that I can convert to csv files for wordpress upload.
    Example
    From Date To Date Date Range
    September 6, 1916 September 29, 1916 Sep 6, 1916 - Sep 29, 1916
    September 1920 October Sep 1, 1920 - October
    September 1921 September - Apr 4, 1905
    1920 Apr 3, 1905 - Jan 0, 1900
    1920 Apr 3, 1905 - Jan 0, 1900
  16. THANK YOU!!!!!
  17. I would like to see how u deal with the 31st of a month and u add 1 month to it. For example add 1 month to 31.05.2016
  18. Nice
  19. Hello sir i wnat to calculate time between 2 date if start date is 26-05-2018 16:00:00 and end date is 27-05-2018 10:10:00 i dont want not calculate time between 17:00:00 to 9:00:00 the answer should be come 2:10:00 hrs how can we do that
  20. I CAN NEVER SEEM TO GET RID OF #VALUE ERROR WHEN I USE DATES. ANY IDEAS ?


Additional Information:

Visibility: 850888

Duration: 19m 6s

Rating: 1766