logo elektroda
logo elektroda
X
logo elektroda
Advanced Search
logo elektroda

Excel - Compare 2 cells with dates to 1 cell with current date.

kruchy95 4614 6
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
| New topic
  • #1 16463976
    kruchy95
    Level 2  
    Hello, please help.
    I need Excel to compare the dates from 2 cells (for me B14 and B15) and (D14 and D15) from cell (A1) If the date from cell D14 and D15 will be the same as in cell A1 or it differs by 2-3 days then in cell D16 it will write Check, and if the dates in cells B14 and B15 will be different than in A1, then in cell B16 it will write Wait.

    Adds a picture of what you want it to look like.

    Excel - Compare 2 cells with dates to 1 cell with current date.
  • ADVERTISEMENT
  • #2 16464021
    Zbych034
    Level 39  
    You can try the IF function.
  • ADVERTISEMENT
  • #3 16464030
    kruchy95
    Level 2  
    @ Zbych034
    And you could write this function (formula) as it would look like in my 2 cases?
  • ADVERTISEMENT
  • Helpful post
    #4 16464075
    Zbych034
    Level 39  
    The function is nicely described in the help. You can first write a function which of the two cells will choose the one you are interested in, then compare it with the cell with the date. Good luck
  • ADVERTISEMENT
  • #5 16464186
    kruchy95
    Level 2  
    But if someone described the formula I would be very grateful. Although I will work fine.

    @Edit
    I don't know which formulas I should use exactly. Do formulas if or that formulas with dates then compare. If anyone is overwhelmed by it, please let me know how this formula should look like. At least an example.
  • Helpful post
    #6 16464591
    Prot
    Level 38  
    kruchy95 wrote:

    what this formula is supposed to look like. At least an example.


    Exactly as in the screenshot :D (just remember to set conditional formatting - colors for text)

    Excel - Compare 2 cells with dates to 1 cell with current date.formSp..JPG Download (31.31 kB)
  • #7 16465606
    kruchy95
    Level 2  
    @Prot

    Thanks a lot for the quick and good help. Subject to be closed. Good luck :D
| New topic
Report a violation of the law

Topic summary

The discussion revolves around using Excel to compare dates in specific cells. The user seeks assistance in creating a formula that checks if the dates in cells D14 and D15 match the current date in cell A1 or differ by 2-3 days, prompting a "Check" in cell D16. Additionally, if the dates in cells B14 and B15 differ from A1, "Wait" should be displayed in cell B16. Responses suggest using the IF function and conditional formatting to achieve the desired outcome, with requests for specific formula examples and clarifications on implementation.
Summary generated by the language model.
ADVERTISEMENT