Solved If Statement using dates

September 10, 2018 at 12:38:59
Specs: Windows 7
I want a formula that will give me "not due", "overdue" or "completed" when comparing 2 dates.

For e.g.

Target Date Completed date
20/12/2018 31/8/2018

I have got this formula so far;

=IF(C5>D5,"Not Overdue",IF(D5>C5,"Overdue","completed"))

If there is a date within completed date I want it to show completed.

Can anyone please help. Thanks in advance.

message edited by kamranosman


See More: If Statement using dates

Reply ↓  Report •

✔ Best Answer
September 12, 2018 at 06:18:51
Thanks I've managed to crack it. The formula I was looking for was;

=IF(N3>0,"Complete",IF(F3<TODAY(),"Overdue","Not Due"))

Thanks for your posts.



#1
September 10, 2018 at 12:47:35
Thanks for telling us what you want. If you would like some help with anything, feel free to ask.

message edited by DerbyDad03


Reply ↓  Report •

#2
September 10, 2018 at 12:53:15
Sorry, don't quite see what you want.
Your formula seems to give you all your asking for.

Perhaps if you post a small example of your sheet, after reading this HOW-TO, which explains the use of < PRE > tags in formatting your data.
Please remember to use Column Letters and Row Numbers.

https://www.computing.net/howtos/sh...

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#3
September 10, 2018 at 13:06:12
"completed" will only show if both dates are the same.If there is no date in completed date I don't want it to show anything, likewise if a date is in completed date then I want it to show completed.

Sorry Is this making sense.


Reply ↓  Report •

Related Solutions

#4
September 10, 2018 at 13:14:44
As Mike noted, we don't know what is in C5 or D5 because you didn't use any cell references when you posted your example data.

re: "If there is no date in completed date"

"completed date" is not a cell reference, so there can't be a date "in" it.

Please click on the following link and post your data using the layout of the example shown in that How-To.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •

#5
September 10, 2018 at 13:26:04
ROW C5 D5 D6

Target Date completed date Result

20/12/2018 31/8/2018 Not Overdue
20/12/2018 ????
20/12/2018 23/8/2018 Overdue

If there is no data in D5 how can I show the result column as blank. Currently its showing as not overdue in my spreadsheet.

Also, if there a completed date I want it to show completed.

Sorry I am new to these forums.


Reply ↓  Report •

#6
September 10, 2018 at 13:39:43
Both myself and DerbyDad asked you to please read this HOW-TO
BEFORE
you posted your data, please do so.

https://www.computing.net/howtos/sh...

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#7
September 12, 2018 at 06:18:51
✔ Best Answer
Thanks I've managed to crack it. The formula I was looking for was;

=IF(N3>0,"Complete",IF(F3<TODAY(),"Overdue","Not Due"))

Thanks for your posts.


Reply ↓  Report •

Ask Question