Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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+RO W()/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 |
#2
|
|||
|
|||
:=IF(G11<TODAY()+50,G11+ROW()/10^10,"")
-- HTH RP (remove nothere from the email address if mailing direct) "Markitos" wrote in message ... 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+RO W()/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 |
#3
|
|||
|
|||
Sorry 40, not 50
:=IF(G11<TODAY()+40,G11+ROW()/10^10,"") -- HTH RP (remove nothere from the email address if mailing direct) "Markitos" wrote in message ... 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+RO W()/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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
looking for a formula | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |