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. Sir whats the formula for next date like today date is 01/01/2019 whats the after 260 days which date will got i need formula for this one sir
  2. So, I need your collective brain power.
    This is a great tutorial. However, I need to schedule dates in the future, on workdays.. However, if the =wrkdy function falls on a weekend, it simply pushes it to the next Monday. I can't have that. I need the weekend dates to get pushed to the Friday before not the Monday after.
    How can I know this out. Essentially, If we schedule these pick up times for the Monday after we are hit with a late fee. I need them there before the weekend, , , if the scheduled time happens to fall on a weekend.
  3. Hi, so I have following problem. I have begin days and end days, and I need to calculate if there is a weekend (Saturday/Sunday) between them.. Could u suggest me some type of solution? Thx
  4. Very Helpful Thank you
  5. Excal me date filter karna h date filter ka option nahi aad raha
  6. 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.
  7. Is there a formula for autofilling month and year only? i.e. if I enter 12 and hit return, it autofills 12-Jan-18.
  8. Thank you very much. I got very useful help
  9. year is also changing using of this format 01.01.2018
  10. 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?
  11. @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?
  12. Month in text - exactly what I needed. Simple but I wouldn't have been able to think about it myself. Thanks, Nicole from Canada
  13. WOW! Read my mind in exactly what I needed. Thanks.
  14. thank you
  15. Excuse me
    If I want to apply tomorrow date or after ....
    Without accept today date
    How it is ????
  16. 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?
  17. Thank you so much
  18. 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
  19. THANK YOU!!!!!
  20. 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


Additional Information:

Visibility: 891351

Duration: 19m 6s

Rating: 1927