Hello, I have such a problem - I need to compare the dates, namely I want to verify that the start date is consistent with the scheduled date. I want him to return the results: before the deadline, on time, after the deadline, and in addition, if he does not indicate the start date of the task,...

Put an additional condition on whether the cell is empty, if it does not count.

Thanks for the answer. What formula?

The file is attached. The comparative date is deliberately entered into the cell because it does not always need the current state.

Check on the cell I corrected. [movie: af298e3c4c] [/ movie: af298e3c4c]

Your formula does not take into account whether the due date has been exceeded. My point is that it should also return this information within one cell. In summary, I am interested in: 1. is it ahead of schedule 2. is it on time 3. is it late 4. if no start date is given, whether or not a start is required due to a reference date (eg today).

However, I can see that it is not that simple. Unfortunately, still not what I mean. Now, if there is no due date, shows NOT GIVEN, the point was to verify whether it is before or after the date for example today. For early start, it shows not required and should ahead of schedule. Perhaps it cannot be done within one formula and you have to break it down into 2 columns ...

Enter the conditions depending on the date and whether the date is given or not.

Excel Date Comparison: Verify Start & Deadline Dates, Return Results Based on Today's Date

dyscan 14469 18

Treść została przetłumaczona

Zobacz oryginalną wersję tematu

Reply | New topic

#1 17641457 21 Dec 2018 09:49

dyscan dyscan

Level 10

» | Helpful post? (0)

Post #1
17641457 21 Dec 2018 09:49

Hello,
I have such a problem - I need to compare the dates, namely I want to verify that the start date is consistent with the scheduled date. I want him to return the results: before the deadline, on time, after the deadline, and in addition, if he does not indicate the start date of the task, he verifies whether or not the date is required in relation to today's date. While there is no problem with the first part of the task, the comparison with today's (set) date is a problem. Excel goes crazy when the column it compares to is empty ...

= IF (E47> G47; "before due date"; IF (E47 = G47; "on time"; "late"))

= IF (D48> F48; "before due date"; IF (D48 = F48; "on time"; IF (F48 = "-"; "ATTENTION !!!"; IF (D48 F51; "before due date"; IF (D51 = F51; "on time"; IF (D51
ADVERTISEMENT
#2 17641576 21 Dec 2018 10:35

kindlar kindlar

Level 42

» | Helpful post? (0)

Post #2
17641576 21 Dec 2018 10:35

Put an additional condition on whether the cell is empty, if it does not count.
#3 17641600 21 Dec 2018 10:46

dyscan dyscan

Level 10

» | Topic author Helpful post? (0)

Post #3
17641600 21 Dec 2018 10:46

Thanks for the answer. What formula?
ADVERTISEMENT
#4 17641611 21 Dec 2018 10:51

Zbych034 Zbych034

Level 39

» | Helpful post? (0)

Post #4
17641611 21 Dec 2018 10:51

Date of today is = today ()
ADVERTISEMENT
#5 17641616 21 Dec 2018 10:56

kindlar kindlar

Level 42

» | Helpful post? (+1)

Post #5
17641616 21 Dec 2018 10:56

Get the file here.
#6 17641638 21 Dec 2018 11:04

dyscan dyscan

Level 10
» | Topic author Helpful post? (0)

Post #6
17641638 21 Dec 2018 11:04

The file is attached.

The comparative date is deliberately entered into the cell because it does not always need the current state.

Attachments:

Zeszyt1.xlsx Download (10.47 KB)
#7 17641753 21 Dec 2018 12:08

kindlar kindlar

Level 42
» | Helpful post? (0)

Post #7
17641753 21 Dec 2018 12:08

Check on the cell I corrected.
[movie: af298e3c4c] https://filmy.elektroda.pl/71_1545390456.mp4 [/ movie: af298e3c4c]

Attachments:

Kopia Zeszyt1-1.xlsx Download (10.34 KB)
#8 17641767 21 Dec 2018 12:17

dyscan dyscan

Level 10

» | Topic author Helpful post? (0)

Post #8
17641767 21 Dec 2018 12:17

Your formula does not take into account whether the due date has been exceeded. My point is that it should also return this information within one cell.

In summary, I am interested in:
1. is it ahead of schedule
2. is it on time
3. is it late
4. if no start date is given, whether or not a start is required due to a reference date (eg today).
#9 17641897 21 Dec 2018 13:26

kindlar kindlar

Level 42
» | Helpful post? (0)

Post #9
17641897 21 Dec 2018 13:26

Once again.

Attachments:

Kopia Zeszyt1-1.xlsx Download (10.36 KB)
#10 17641939 21 Dec 2018 13:52

dyscan dyscan

Level 10

» | Topic author Helpful post? (0)

Post #10
17641939 21 Dec 2018 13:52

However, I can see that it is not that simple.

Unfortunately, still not what I mean. Now, if there is no due date, shows NOT GIVEN, the point was to verify whether it is before or after the date for example today.

For early start, it shows "not required" and should "ahead of schedule".

Perhaps it cannot be done within one formula and you have to break it down into 2 columns ...
#11 17641959 21 Dec 2018 14:04

kindlar kindlar

Level 42

» | Helpful post? (0)

Post #11
17641959 21 Dec 2018 14:04

Enter the conditions depending on the date and whether the date is given or not.
#12 17641986 21 Dec 2018 14:30

dyscan dyscan

Level 10

» | Topic author Helpful post? (0)

Post #12
17641986 21 Dec 2018 14:30

I think I will give up and they will do it manually ...

Until I don't believe it can't be done.
#13 17642119 21 Dec 2018 15:36

Zbych034 Zbych034

Level 39

» | Helpful post? (0)

Post #13
17642119 21 Dec 2018 15:36

It is possible, but you need more commitment, the matter is simple and you have already given the basics.
#14 17642179 21 Dec 2018 16:10

dyscan dyscan

Level 10

» | Topic author Helpful post? (0)

Post #14
17642179 21 Dec 2018 16:10

I've been thinking about it for a long time.

I love the "know-but-not-say" answers.
#15 17642284 21 Dec 2018 17:12

Zbych034 Zbych034

Level 39

» | Helpful post? (+1)

Post #15
17642284 21 Dec 2018 17:12

And I think you expect a ready
Decompose a function into individual elements (for one condition) and then play with a compound function. Help is in the program, you just have to want to use it. if you want a cash from me, make a transfer to any foundation at least PLN 50 (you choose which one) and I will socially do the job for you. I don't feel like it otherwise. It is your choice and do not assume that it cannot be done
ADVERTISEMENT
#16 17642288 21 Dec 2018 17:16

dyscan dyscan

Level 10

» | Topic author Helpful post? (0)

Post #16
17642288 21 Dec 2018 17:16

I don't want to help, don't help.

Better spend this time with your family.
#17 17642295 21 Dec 2018 17:21

Zbych034 Zbych034

Level 39

» | Helpful post? (0)

Post #17
17642295 21 Dec 2018 17:21

Help not do it for someone
Don't worry about my family (kids long gone)
I finish this because I don't like people with a demanding attitude
#18 17642317 21 Dec 2018 17:31

dyscan dyscan

Level 10

» | Topic author Helpful post? (0)

Post #18
17642317 21 Dec 2018 17:31

Nevertheless, I wish you all the best for Christmas and the whole new year.
#19 17642320 21 Dec 2018 17:33

Zbych034 Zbych034

Level 39

» | Helpful post? (0)

Post #19
17642320 21 Dec 2018 17:33

thank you, the same to you
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Reply | New topic

Report a violation of the law

Topic summary

The discussion revolves around a user's challenge in Excel regarding date comparisons for task management. The user seeks to verify if a start date aligns with a scheduled deadline, returning results such as "before due date," "on time," or "late." Additionally, the user wants to check if a start date is required based on today's date when no start date is provided. Various responses suggest adding conditions to handle empty cells and using the TODAY() function for current date comparisons. The user expresses frustration over the complexity of creating a single formula to achieve all desired outcomes, considering breaking it into multiple columns. Some participants offer assistance, while others suggest that the task is manageable with proper commitment and understanding of Excel functions.
Summary generated by the language model.