Formula that tells me whether a date is later than the current.

[VivatMartin]

Hi all,

First post on here, but I have read other answers on here, and you all seem very helpful and intelligent!

I have been tasked by a Director to create a spreadsheet that decides if a date is compliant or not... For it to be compliant, it has to be within 10 months of the last accounts done. So, I have managed to do a (relatively) simple " =DATE(YEAR(D2),MONTH(D2)+10,DAY(D2)) " to work out when they would stop being compliant, however, what I want to know now is how to make a formula that would tell me if that date was after the current, for example, if the date was: "30/07/2012" it would say "No" however, if it were "31/10/2012" it would return a "Yes".

Looking forward to testing out what I am sure will be all of your very smart and rapid responses and suggestions.

Many thanks,
Martin

[dilipandey]

Hi Martin,

Welcome to the forum.

You can use the logic as :-

=if("your date formula">30/07/2012,"No", "Yes")

You just need to change the logics of ">" and "<" and if still have issue, would suggest you to upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[daddylonglegs]

If your "D2 + 10 months" formula is in E2 then try this formula

=IF(E2<TODAY(),"No","Yes")

[VivatMartin]

Hi, thank you for your speedy reply.

Sorry it seems that I was unclear

I need to be able to have it compare the date to the current.

For example, if i have compliant end date as 31/12/04, obviously that is not within 10 months of now, and so would not be compliant.

I will attach a sample workbook for you to test

I have edited names of entities and administrators only, so cell references should be fine.

Thanks
Martin

Mock Table.xls

[VivatMartin]

Thank you very much.

This worked an apsolute treat.

Many thanks

Martin

P.S. I knew I would end up looking stupid because it would be something simple!