Comments on: Excel date functions with formula examples

This is the final part of our Excel Date Tutorial that offers an overview of all Excel date functions, explains their basic uses and provides lots of formula examples. Continue reading →

Comments page 3. Total comments: 377

  1. I'm not sure if this relates specifically to any of the month formulas, but I'm trying to calculate vacation accrual each month. How can I have a specific value added to a cell automatically on the first day of each month? So, add 15 hours every 1st of the month to one cell, to continually show my vacation balance. Thanks!

  2. I have 3 columns representing dates of vaccination (1st dose, 2nd dose, 3rd dose dates). I have another column with visit dates. I must compare dates of vaccination to visit date- to see how many doses they had prior to the visit date. How can i do this. some time the first dose can be blank as they are unvaccinated.

    1. Hello!
      If I got you right, the formula below will help you with your task:

      =SUM((A1:C1 < D1)*(A1:C1 < > ""))

      D1 - visit date
      A1:C1 - dates of vaccination

  3. Hi, is there a way to get the nth day based on a specified start month?

    Day 0 is May 1, 2022
    Day 1 is May 2, 2022, and so on.

    If I were to input Jun 15, 2022, can it provide me what Day it is?

    Thanks in advance!

  4. I am trying to figure out if there's a way to get a "live count" on a spreadsheet. For example, I deal with people with terminal illnesses. I'm trying to track their lifespan from the date of the diagnosis to see how long their lifespan is. I have it figured out once they pass away. Is there a way to have a formula that will update each day that passes from the "start date" (which is the diagnosis date)... but there is no end date yet?

    Example E1 is the diagnosis date 1/20/2022, F1 is blank because there's no deceased date yet, and G1 will show "5" because today is the 5th day. Then tomorrow, it will automatically roll to "6" for the 6th day. Is this even possible to do in excel?

  5. Hi guys, I need help with this.

    Trying to set today date into a cell with 25.12.2021

    I keep getting 12/25/2021 when I use TODAY()

    Any help?

      1. Hi Alexander,

        Can a formula do that without going to custom formatting?

        I'm trying to use a bot to set the text in the cell. This cell is also referenced by some other cells.

        If there is a formula for this I will really appreciate.

        1. Hi!
          I guess you haven't read the manual from the link I gave you. There is a paragraph: How to change date format in Excel. You don't need to apply conditional formatting.
          By the way, no Excel formula can change the cell format. This can be done either manually or using a VBA macro.

  6. When I try put a date inside of if, it's doesn't work.

    For example, put this formula: =IF(A2>"6/30/2039";"6/30/2039";A2)

    Could you see is there something wrong?

  7. I want to set up a tracker for completion of mandatory training. The training is due to be completed on induction and then every 3 years following but in a specific month. I am having trouble with rounding the year over where induction is, say October, and the training is due to be completed in January. For example, the training was completed on induction on 28/10/2021 and needs to be completed every 3 years following in January. So the next training would be due 28/01/2025 as otherwise it would be only 2 years and 3 months until the next training.

    I have developed the following formula for the Next Completion Due cell (where cell D3 is the date the training is completed):

    =IF(OR(D3=DATE(,1,),D3=DATE(,2,)),DATE(YEAR(D3)+4,1,DAY(D3)),DATE(YEAR(D3)+3,1,DAY(D3)))

    The problem I am having is that regardless of what month I put in the D3 cell, the year is not rolling over to the next year where the training is completed in March or later (still using the January example).

    So when I enter 28/1/2021 the next completion date using the above formula comes out as 28/1/2024, but when I enter 28/10/2021 the next completion date using the above formula also comes out as 28/1/2024 (and not 28/1/2025 as I am intending it to be).

    Any ideas on how to get this to work for me would be greatly appreciated.

    Thanks.

    1. Created a report due date calculator to track when a report is due. (It is due no later than 16 days from admit date, but by Wednesday of that due week...) I am getting all the correct returns, with the exception of Tuesday Admits should be the same due date as the Wednesday Admits (all others are calculating as they are required per the client).
      The formula I used is to generate my due date is: =IF(B15="","",B15+14-MOD(B15-4,7))

      Not even sure if it is possible, but hoping! this error in due date only occurs on that every other Tuesday date, because it gets a little longer grace period than the others.

      Admit Date Report Due
      12/6/21 12/15/21
      12/7/21 12/15/21 (this one needs to be 12/22)
      12/8/21 12/22/21
      12/9/21 12/22/21
      12/10/21 12/22/21
      12/11/21 12/22/21
      12/12/21 12/22/21
      12/13/21 12/22/21
      12/14/21 12/22/21 (this one needs to be 12/29)
      12/15/21 12/29/21

      1. Hello!
        If I understand your task correctly, the following formula should work for you:

        =A2+16-WEEKDAY(A2+16,14)

        This should solve your task.

        1. This new formula worked perfectly! Thank you so much!

          1. Works perfect! I just added in the portion to "hide" the date when it is blank:
            =IF(B7="","",B7+16-WEEKDAY(B7+16,14))

            Thanks again!

  8. How to calculate commission

    Source :
    1)company
    2) ref

    If source Ref :
    Ref benefits
    1)01-07-2020 to 31-12-2020
    (1st ref benefit-2000)
    (2nd ref benefit -30000 and)
    (3rd ref benefits 40000)
    2) 1-1-2021 to 31 march 2021
    (1st ref benefit 25000)
    (2nd ref benefits 25000)
    ( 3rd benefit 25000)
    3) 01-04-2021 To 31-03-2022
    ( 1 ref benefits 50000)
    ( 2nd ref benefit 50000)
    ( 3rd ref benefit 50000)

    If source company benefits
    Brokerage 3%
    =value *brokerage commission

    Please help how to calculate in one column?

    1. Please help

  9. Hello Alex, just want to ask. How to know the difference between to dates in one formula.
    Ex Jan 2021 and March 2021
    or March 2021 and Jan 2021

    Tried using DATEDIF but having error for negative months. Thank you!

  10. Hi.. I need help. I have column A (hire date) and B(termination date)

    Hire date 01/01/2000
    Termination date 20/04/2021

    How i want to calculate number of day started from 01/07/2020 - until termination date?

    Appreciate your help

  11. Hello,

    I am trying to return a payroll date based on a hire date for incentive. The incentive is paid after 2 months of employment. I can use EDATE to calculate the 2 month date, but need to have the result hit the corresponding pay date. We have 24 pay periods so our pay dates are on the 15th and the final day of the month. I need the result to return one of those two days based on when the day the 2 month anniversary is hit. i.e.
    Hire Date = 1/5/21
    2 months = 3/5/21
    Pay Date = 3/15/21

    but if that person was hired on 1/18/21, then they would be paid on 3/31/21. How can I get those pay dates to calculate automatically?

  12. Is there an MS Excel formula that determines the date/year of retirement after 60 years of age when the date of birth is known?
    I will be very grateful!

    1. Hello!
      Add 60 years to your date of birth as described in this article. You will receive the date you want.
      I hope I answered your question. If something is still unclear, please feel free to ask.

  13. How to find smallest of set of dates.

  14. I would like to be able to conditional format cells that are within 30 days of a date shown in a cell

    How would i do this?

    Many thanks

  15. I am looking to add a review date to a contract expiry date and convert it the month.

    For example: expiry date is 02/09/2021 and I need to set the review date 90 days before.
    I have =09/09/2021-90 and it returns 09/06/2021 but I would like to it to return June?

  16. Can I conditionally format a column to let me know if the date I type in is a future date?

  17. HI,

    I would like to know that i have date in a column(Ex: A2) which has to find if the same date fall between any given period.

    Ex: 10-Feb-2021 located in column A2

    Period: 1-Feb-2021 to 28-Feb-201 (located in another column)

    Same kind of details need to find out multiple employee leave details

    if A2 date fall between that particular period then i need to keep the remarks or need to highlight.

    Thanks in advance for your assistance

  18. I am trying to figure out how to insert a date if the cell is not blank. As in when A2 is not blank, then B2 fills in today's date. I have tried various formulas and keep getting an error.

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =IF(A2<>"", IF(B2="",NOW(), B2), "")

      To prevent your date from automatically changing, you can use several methods:
      1. Use the recommendations from this article in our blog.
      2. Replace the date and time returned by the TODAY function with their values. Copy the date (CTRL + C), then paste only the values using Paste Special or Shortcut CTRL + ALT + V.
      I hope my advice will help you solve your task.

  19. I have a monthly payments due date what is the formula? Also I have couple of yearly (annually) payment due date so what is the formula for yearly date?

  20. Is there a way to have the current date that will not update? I'm trying to track compliance dates - so for example when column D=0 column E will show the date that D first equaled 0.

      1. Yes! - Thank you!!

  21. I’m a senior nurse trying to figure out what formula I can use to get the duration (in hours) between 2 dates with times.
    The way the cells are configured is
    08/10/2018 06:00
    06/11/2018 19:00
    Please help

    1. Hello!
      Use a subtraction formula

      =B2-A2

      In a cell with a formula, apply a custom time format

      "37:30:55"

      I hope this will help, otherwise please do not hesitate to contact me anytime.

      1. Amazing thank you

  22. Hello,

    I have a document that has a date in text form listed like Nov/19. When I use the date value formula, the formula converts it to Nov/20. Is there a formula I can use that will convert the text to the correct date?

    1. Hello!
      Unfortunately, I was unable to repeat your mistake. Please state exactly how your date is written. What formula are you using? What is the default date format?

  23. Hi Expert,

    How do I make the cell auto change for Due date (a fixed date) when the date is change (Actual Start Date - Plan Start Date(a fix date)). Can someone help please ?
    Example:
    Plan Start Date: 01/11/2020 (fixed)
    Actual Start Date: 05/11/2020
    Difference: 5 days
    Due date : 30/10/2020 (fixed) + 5 days - this cell will auto change to 05/11/2020

    So basically whenever have changes to Actual Start Date, Due date cell will change automatically based on the difference days count.
    What's the formula to use in this situation ?i Thanks !

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =C1+(B1-A1)

      A1 -start date
      B1 - actual start date
      C1 - due date

      1. Hi Alexander,

        Thanks for the reply, appreciate it. But that is not that what i want.

        Plan Date Actual Start Date
        01-Nov (A1) 05-Nov (B1)

        Due date
        30-Oct (B4)
        03-Nov (B5)

        My task is to make B4 and B5 to change automatically based on the difference between B1-A1. So my question is, what formula to put in cell B4 and B5 (already has a date in the cell) to make it both auto change based on the day difference. Hope it more clearer for you.

        Appreciate much your helps !

        1. Hello!
          On our forum, we have already written many times that if there is some value in a cell, then the formula cannot be written into it. Your task can be solved using the VBA macro. It is impossible to solve it using an Excel formula.

  24. Hi,
    Am still using excel 2007. So Daily making invoices by date by date. Suddenly when I open the old invoice for checks it’s showing as TODAYs date(current) .. so I need to solve that when opening old document. is there anyone can help me plz

  25. Hi,
    Is there any formula to return previous day if the time is between 00:00 ~ 05:00 hrs

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =IF(AND(HOUR(B1)>0,HOUR(B1)<5),B1-1,B1)

  26. Hello Alex,
    What if instead of invoice date, it should start from the end of transaction week? Every Friday is the starting date but the invoice date is any date like April 1 Wednesday and 13, 2020 Monday. Thanks

    1. Hello Myra!
      It is a pity that you did not immediately indicate all the conditions. It would take significantly less time.
      Please try the following formula

      =A3+(5 > WEEKDAY(A3,2))*(5-WEEKDAY(A3,2))+(5 < WEEKDAY(A3,2))*(12-WEEKDAY(A3,2))+57

      A3 is the invoice date.

      1. Hello Alex,
        Sorry for the late reply. Wow, that's a long formula. Will try to understand this. Thank you for helping me. Stay safe always. :)

  27. What is the formula to put two strings together. I need =DATEDIF(A1,A2,"M") but if the A2 is blank calculate by "today" =DATEDIF(A1,"TODAY(),"M")

    1. Hello Bonnie!
      The formula below will do the trick for you:

      =IF(A2="",DATEDIF(A1,TODAY(),"m"), DATEDIF(A1,A2,"m"))

      I hope it’ll be helpful.

      1. hi sir

        if 07-Aug-19 : 26 -Feb-2020 =DATEDIF(07-Aug-19,26 -Feb-2020,"d") =569days and the next month

        7-Sep-20219: 26-Feb-2020 =DATEDIF(07-Sep-19,26-Feb-2020,"d") =538days

        how to formulate the total days in 19months" 07-Aug-19, to 26 -Feb-2020 =5,592

  28. Hi,
    How do I calculate the days completed based on the ()Todays (current date) from a start date and an end date, please?
    Example:
    Start Date: 20/04/2020
    End Date: 10/05/2020
    Today's Date: 26/04/2020
    Numbers of days completed:?
    What's the formula to calculate the number of days completed, taking into account the end date?

    1. Hello Emmanuel!
      If I understand your task correctly, please try the following formula:

      =DATEDIF(A1,TODAY(),"d")

      where A1 - Start date.
      You can learn more about DATEDIF in this article on our blog.
      Hope you’ll find this information helpful.

  29. Hi,

    How do I add a leap year into an excel formula. I have one set for the Julian calendar which works off a number per day of the year for each of the 365 days. However, I cannot get it to figure out leap years. The formula I am using at the minute is: =IF(C2="","",DATE(YEAR(TODAY()),1,C5)). C2 is where we put the code and C5 is the date.

    Thanks

    1. Hi Matthew,
      The same formula you sent will work in leap year too. It will simply consider February 29th as the 60th day of the year.

      If however, you need to check if the year is leap or not, here is the formula for you:
      =IF(MOD(YEAR(A1), 4), "normal year", "leap year")

      Where A1 is the cell with a date.

  30. Hi,

    If I use the formula for today's date, will the date update every day?
    I'm looking for a formula to log the current date when a certain value is reached, but if the TODAY formula updates to current day I won't be able to log the date the value is reached.
    Can someone please clarify how this works? And if it does only give the current date, can you please let me know if there is a formula to log the current date and not update daily?

    Thanks,
    Tyler

    1. =IF(B9>0, TODAY(), "" )

      8 | A | B |
      9 | 12/14/2019 | Reachable value |
      10 | | If Reachable is Null then A-10 show is empty |

    2. Hi Tyler,

      Yes, the TODAY formula updates automatically to always show the current date.

      If you are looking to insert today's date as an unchangeable time stamp, this can be done with the Ctrl + ; shortcut or a more complex formula that uses a circular reference. You can find full details in How to insert today date & current time as unchangeable time stamp. However, using circular references in Excel is always a risk, so please be sure to weigh all pros and cons carefully before using that formula in your worksheets.

    3. not sure what you are asking, current date is not current if it doesn't update

  31. start date and end date is greater than 6 months then count full year.
    for example
    01-01-2000 to 02-04-2019 the answer is 28 year 6 months and 1 day
    but i get the only 29 year only
    01-01-2000 to 01-04-2019 the answer is 28 year 5 months and 30 days
    but i get the only 28 year only
    any formula in excel

    1. try it
      =DATEDIF(B1,B2,"y")&" Years " & DATEDIF(B1,B2,"ym")&" months " & DATEDIF(B1,B2,"md")&" days "

      1. Hi .. i have problem , how to make month and year only to combine, and otomatis.
        example :

        the label show only "2212" how to make this formula
        thank you

    2. try to this type of formula you will get

  32. I need to make daily sign-in sheets for company visitors. Is there any way to make one sign-in sheet and have the working days populate for the rest of the month?

    1. I can help you out for your query.But tell me one thing that you said "1 sign-in-sheet and have the working days populate for the rest of the month". Does this mean you want to calculate the present days for the visitors or the remaining days of that particular month?

      1. Not OP, but it would be great to calculate the present days for the visitors up to a certain date. For example, a sign-in-sheet that begins at a certain date, counts up to, and then ends after a period of time like 3 months.

  33. Hello, please let me know if a return of "year.month.day" is possible. So the column A would be:
    2018.01.01
    2018.02.24
    2018.03.13
    Etc,

    Thanks.

    1. Hello!

      If column A already contains dates, you can simply set this custom format for them: yyyy.mm.dd

      For this, select the dates, press Ctrl+1, on the Number tab select Custom in the Category list, and type the above code in the Type box. For more information, please see How to create a custom date format in Excel.

  34. Hi,

    Can i get an exact date from this only "Sept-2018"

    I am creating a table where I just need to replace the specified cells details then change the date on one column.

    Thanks ahead!

    1. I think not possible

  35. I am trying to get an IF formula to recognize a date entry so if the cell G9 contains a date, then return the value in cell F6 e.g. If(G9="date",$F$6) - however my formula is returning a result of FALSE even though there is a date in G9 which is 11/07/2016 in the format of dd/mm/yyyy. Any help appreciated, I have tried everything instead of "date" in the formula, I have used "dd/mm/yyyy" "number" "datevalue" but nothing is returning back the value in F6, I'm either getting FALSE or errors of #NAME? or #VALUE?

    1. Dear MC,
      Change the formula to
      =If(G9>10000,$F$6) or
      =If(isnumber(G9),$f$6,"False")

      In Excel date is a number.
      1 Jan 1900 = 1;
      2 Jan 1900 = 2 and so on.
      11 July 2016 = 42562, regardless of which number format you use.

      I hope this solves your problem.

      Regards,

      Vijaykumar Shetye,
      Panaji, Goa, India

  36. what does mean this formula ?

    =w(B15,B16,0)

    what does mean =W ?

    Thanks

    1. Tarek:
      I would say the "W" is a typo. I'm not aware of an Excel function "W". Either that or maybe it is a user defined macro.

  37. HI,

    example
    11/12/2017 - 5/3/2018 HOW MANY DAYS BALANCE COMING

    1. Hi,

      If your task is to calculate the number of days between two dates, I'd recommend you to try out our Date & Time Wizard. To see how the add-in works, you can download and install the fully functional 14-day trial version of Ultimate Suite that contains all our add-ins for Excel (70+). After the installation, you'll find Date & Time Wizard under the Ablebits Tools tab.

      If your task is different, then please describe it in more detail.

  38. Hi All,

    Please help me for this. I have 3 different wordings in one column like TYPED, SEND & RECEIVED. Now I need to put date on next column like when I typed "TYPED" word on that column then in next column it need to show the current date, but wont change in next day when i open the excell on next day.

    Like this when I put next word (i.e) "SEND" the current date has to be displayed and also wont change in next day when I open excell in next day.

    If anyone can help me in this please help me.

    Thanks,
    Faizal

    1. Hello,

      I'm afraid there's no easy way to solve your task with a formula. Using a VBA macro would be the best option here.

      However, since we do not cover the programming area (VBA-related questions), I can advice you to try and look for the solution in VBA sections on mrexcel.com or excelforum.com.

      Sorry I can't assist you better.

  39. please help me
    i want to calculate number list in one number.
    i want like this
    {1+5+8+16+7+26=63>>> but i want 6+3=='9'}
    {19+15+32+16+167+366=615>>> but i want 6+1+5=='3'}
    {451+456+268+176+9+256=1616>>> but i want 1+6+1+6=='5'}
    i want '9','3'&'5' number count formula in excel.

    1. Dear Sudesh,
      Use the formula
      =SUM(IFERROR(VALUE(IF(COLUMN(A1:J1)=COLUMN(A1:J1),MID(SUM(IFERROR(VALUE(IF(COLUMN(A1:J1)=COLUMN(A1:J1),MID(A2,COLUMN(A1:J1),1),0)),0)),COLUMN(A1:J1),1),0)),0))

      Formula will provide the sum of the digits like 123456 as 3.

      If you also want to get the first stage of the sum of digits, then you can use the following formula.
      =SUM(IFERROR(VALUE(IF(COLUMN(A1:J1)=COLUMN(A1:J1),MID(A2,COLUMN(A1:J1),1),0)),0))

      This will give result of 123456 as 21.

      Note:
      1. Change the cell references as required.
      2. Presently number is in cell A2.
      3. Formula is to be entered as Array Formula, using Control+Shift+Enter, instead of Enter.

      Regards,

      Vijaykumar Shetye,
      Panaji, Goa, India

    2. Hello,

      I'm afraid there's no easy way to solve your task with a formula. Using a VBA macro would be the best option here.

      However, since we do not cover the programming area (VBA-related questions), I can advice you to try and look for the solution in VBA sections on mrexcel.com or excelforum.com.

      Sorry I can't assist you better.

  40. I have a spreadsheet that I sometimes keep open for several days. I have the TODAY() function in one cell. There are many other cells that refer to this for date calculations.

    Without saving/reopening, is there a way to trigger an update automatically after midnight? Executing the cell the next day doesn't update.

    1. Hello,

      I'm afraid there's no easy way to solve your task with a formula. Using a VBA macro would be the best option here.

      However, since we do not cover the programming area (VBA-related questions), I can advice you to try and look for the solution in VBA sections on mrexcel.com or excelforum.com.

      Sorry I can't assist you better.

  41. I want to know how I can use the Duration Days and Start Date to get the End Date.

    Example

    Duration Days Start Date End Date
    24 11/30/17

    1. Hello,

      Please try the following formula:

      =TEXT(DATEVALUE("11/30/17")+24,"mm/dd/yy")

      Hope it will help you.

  42. Hi,

    I would like to change a date automatically to today's date once data is changed in another column.
    e.g Column A is a Serial Number, Column B is the software Version, Column C is whether Serial Number has updated Software Version = 0 for no and 1 for yes. Column D is the date the software was updated. I would like to know what formula to use when we change the software version ... column D should automatically update to today's date.

    If this is unclear, i will send the spreadsheet for clarity.

    1. Hello, Maryka,

      I'm afraid there's no easy way to solve your task with a formula. Using a VBA macro would be the best option here.

      However, since we do not cover the programming area (VBA-related questions), I can advice you to try and look for the solution in VBA sections on mrexcel.com or excelforum.com.

      Sorry I can't assist you better.

  43. I have a problem
    In sheet1 i have a table which is
    A B C D E F
    _____________________________________________________
    1 Date Qnty
    2 29/07/2017 130
    3 07/08/2017 300
    4 07/08/2017 220
    5 10/08/2017 140
    6 21/08/2017 50
    7 07/09/2017 100

    I want to put data which is on 06/08/2017 i.e data required nearer to 06/08/2017 (it's 07/08/2017)in cell E2
    How can i do
    please guide

    1. Hello, dibya,
      I'm afraid there's no easy way to solve your task with a formula. Using a VBA macro would be the best option here.
      However, since we do not cover the programming area (VBA-related questions), I can advice you to try and look for the solution in VBA sections on mrexcel.com or excelforum.com.

      Sorry I can't assist you better.

  44. I want to create conditional formatting in one cell based on the date input of another cell. However, I do not know the value of the date. Is there a formula that says "whatever the date value entered in the cell + 1" for example? I am trying to calculate when something goes past due, but I do have an assigned date yet.

    Thanks in advance

    1. I meant that I DON'T have an assigned date yet.

  45. Can any one help me to create formula in Excel sheet for calculating tax 5% on or before 14/9/2016 and 6% from 15/9/2016 with the help of IF Statement.
    _________________________________________________
    A | B | C | D |
    _________|____________|_____________|____________|
    Date Amount Tax @5% Tax @6%
    5/9/2016 5000 ? Formula ? Formula
    14/9/2016 25000
    15/9/2016 27400
    25/9/2016 125000
    5/7/2016 215600
    5/4/2016 15000
    25/10/2017 2000

    1. Hello, Nitin,

      If I understand your task correctly, please put the formula below to cell C2:
      =IF(A2<="14/9/2016", B2*5%,"")

      and the next one to D2:
      =IF(A2>"14/9/2016", B2*6%,"")

      you need to copy both formulas down the columns. If you don't know how to do that, please check out this article.

      Hope it will help!

      1. To Natalia
        thanks you have solved my big problem.

  46. Hi There! Can you help me with this calculating the days from dates please? I want to add say 3/16/2017+3/20/2017 and see the result at 4.

    Thanks for your help!

    Cory

    1. Hi, Cory,

      if A1 contains 3/16/2017 and A2 - 3/20/2017, the following formula will return 4:
      =$A$2-$A$1

      Or you can use the other one:
      =DATEVALUE("3/20/2017") - DATEVALUE("3/16/2017")

      Hope this helps!

  47. I have a column of expiry dates. I need to display those dates that are going to expiry in the next two to three weeks.

    thanks in advance.

    1. Hello, Santa,

      you need to use Conditional formatting here.
      If the dates are in column A, you create a rule that will be applied to A:A with the following condition:
      =(A1+14)>TODAY()

      Please use the link above to learn how to create and use conditional formatting in Excel.

  48. I want to enter a formula that debits an amount based on date.
    Cell A1 = todays date. Other cell rows have transactions posted which i do want to happen unless it is at or past cell A1. Thank you

    1. Hello, Marc,

      could you please clarify what values you have in other cells? Are those some dates that you want to compare to A1?

  49. Looking for a function where for eg you type in a statement date (30/06/2017) it will pick up everything in the other worksheets pertaining to that particular date/month - what formula do I use...that's if I am making any sense:)

    1. Hello, Mel,

      Well, this is an interesting questions, since we don't know how your lookup data is stored and whether you want to pick up a row/a column or something other than that.

      For now, I can advise you to take a look at a few functions that may help:
      VLOOKUP
      HLOOKUP
      IF
      INDEX/MATCH

      Or, a simpler method is to try our Merge Tables Wizard that can do that for you :)

  50. Hi,

    I have a problem in calculating the EOSB using IF funct.
    We have system which generates the calculation for us but I want excel function to help double checking my results.

    The rules are as follows:

    5 years gets full salary

    thanks

    1. Hi,

      I have a problem in calculating the EOSB using IF funct.
      We have system which generates the calculation for us but I want excel function to help double checking my results.

      The rules are as follows:

      5 years gets full salary

      thanks

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)