formula to alert if expiring within 40 days

HI,

I am currently using a conditional formula that will tell me when a field
with a date input will expire with the current month.
the formula I am currently using
is:=IF(DATE(YEAR(G11),MONTH(G11),1)<TODAY(),G11+ROW()/10^10,"")

but i was trying to find something that would tell me of a date expires with
40 days, no matter if this is the current month or not.

thanks for your help.
Markitos

:=IF(G11<TODAY()+50,G11+ROW()/10^10,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Markitos" <Markitos@discussions.microsoft.com> wrote in message
news:EB031E8B-1BE4-4B91-ACE2-842CC30D6FD3@microsoft.com...
> HI,
>
> I am currently using a conditional formula that will tell me when a field
> with a date input will expire with the current month.
> the formula I am currently using
> is:=IF(DATE(YEAR(G11),MONTH(G11),1)<TODAY(),G11+ROW()/10^10,"")
>
> but i was trying to find something that would tell me of a date expires
with
> 40 days, no matter if this is the current month or not.
>
> thanks for your help.
> Markitos

Sorry 40, not 50

:=IF(G11<TODAY()+40,G11+ROW()/10^10,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Markitos" <Markitos@discussions.microsoft.com> wrote in message
news:EB031E8B-1BE4-4B91-ACE2-842CC30D6FD3@microsoft.com...
> HI,
>
> I am currently using a conditional formula that will tell me when a field
> with a date input will expire with the current month.
> the formula I am currently using
> is:=IF(DATE(YEAR(G11),MONTH(G11),1)<TODAY(),G11+ROW()/10^10,"")
>
> but i was trying to find something that would tell me of a date expires
with
> 40 days, no matter if this is the current month or not.
>
> thanks for your help.
> Markitos