Hello,

Could someone please help me with a formula that does the following?

In cell H5 I need a formula that does the following:

In cell G5 is a date.

In cell A12 is today's date.

If today's date in cell A12 minus the date in cell G5 equals zero, then
display the words "Expired" in cell H5.

If today's date in cell A12 minus the date in cell G5 is less than
(-31), then display the words "Current" in cell H5.

If today's date in cell A12 minus the date in cell G5 is between (-24)
and (-31) inclusive, then display the words "Due Soon" in cell H5.

I tried a nested IF statement but could not get it to work.

Any help would be greatly appreciated.

Thanks,

Chris.

Live Long and Prosper :-)

*** Sent via Developersdex http://www.developersdex.com ***

Hi Chris:

Here is a formula you can use:

=+IF(AND(A12-G5<-24,A12-G5-31),"Due
Soon",IF(A12-G5<-31,"Current",IF(A12-G5=0,"Expired","Other")))

The is an 'Other' category for those where the date is greater than -24 days.

I hope this helps. Please post if this satisfies your request.

Cheers.

"Chris Hankin" wrote:

Hello,

Could someone please help me with a formula that does the following?

In cell H5 I need a formula that does the following:

In cell G5 is a date.

In cell A12 is today's date.

If today's date in cell A12 minus the date in cell G5 equals zero, then
display the words "Expired" in cell H5.

If today's date in cell A12 minus the date in cell G5 is less than
(-31), then display the words "Current" in cell H5.

If today's date in cell A12 minus the date in cell G5 is between (-24)
and (-31) inclusive, then display the words "Due Soon" in cell H5.

I tried a nested IF statement but could not get it to work.

Any help would be greatly appreciated.

Thanks,

Chris.

Live Long and Prosper :-)

*** Sent via Developersdex http://www.developersdex.com ***

Thanks thechilipino for all your help - very much appreciated.

Cheers,

Chris.

Live Long and Prosper :-)

*** Sent via Developersdex http://www.developersdex.com ***