C
Chris Hankin
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
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