Dates

[Kwesi Quartey]

Hi All 

I have another question I seem to stuck I'm doing a sheet

Outstanding	Dates
> 6 months	07/01/2020
Between 3 - 6 Months	14/01/2020
Between 3 - 6 Months	17/01/2020
< 3 months	20/01/2020
< 3 months	23/01/2020

what I want to do is when to input the "date" into the "Outstanding" cell I just want it to return "> 6 months" for example 

[#2]

@Kwesi Quartey

Hi,

The question is not clear
Please explain it so we can help.

Regards

[#3]

Hi Haytham
I mean I'm trying to work with this e.g

Outstanding Dates Period
> 6 months 07/01/2020 2010/02

I want to do is when I enter the "period" date eg 2010/02( yy/mm), this would check against the "dates" (dd/mm/yy) and then output "Outstanding" as > 6 months for eg.

I need a way for excel to work out the difference between both different date formats and to output a return based on the difference between the dates

[#4]

@Kwesi Quartey

If so, try this formula below and find it in the attached file:

=IF(B2-DATE(LEFT(C2,4),RIGHT(C2,2),1)>160,"> 6 months",
IF(B2-DATE(LEFT(C2,4),RIGHT(C2,2),1)<90,"< 3 months",
"Between 3 - 6 months"))

 Hope that helps

[#5]

@Haytham Amairah thanks! i'll give this a shot