How do I set up a notification for expired items in Excel?
 

Is there a function that I can set up to notify me when a contract expires?
I use an Excel spreadsheet to track contracts and insurance certificates and
dates and so on. I was thinking there should be a way to produce a
notification when a certain cell with a date entered expires - make sense?

Thank you

How do I set up a notification for expired items in Excel?
 

If your dates start in A1, put this in B1 and drag down:

=IF(A1<TODAY(),"Expired Contract","")


--
Regards,
Dave


"Striving for efficiency" wrote:

Is there a function that I can set up to notify me when a contract expires?
I use an Excel spreadsheet to track contracts and insurance certificates and
dates and so on. I was thinking there should be a way to produce a
notification when a certain cell with a date entered expires - make sense?

Thank you

How do I set up a notification for expired items in Excel?
 

I never was good with IF statements...can you explain this? I get confussed
with all of the punctuations: () "," thank you

"David Billigmeier" wrote:

If your dates start in A1, put this in B1 and drag down:

=IF(A1<TODAY(),"Expired Contract","")


--
Regards,
Dave


"Striving for efficiency" wrote:

Is there a function that I can set up to notify me when a contract expires?
I use an Excel spreadsheet to track contracts and insurance certificates and
dates and so on. I was thinking there should be a way to produce a
notification when a certain cell with a date entered expires - make sense?

Thank you

How do I set up a notification for expired items in Excel?
 

Check the help menu for an in depth explanation of it, basically:

=IF(condition_you_want_to_test , value_if_true , value_if_false)

--
Regards,
Dave


"Striving for efficiency" wrote:

I never was good with IF statements...can you explain this? I get confussed
with all of the punctuations: () "," thank you

"David Billigmeier" wrote:

If your dates start in A1, put this in B1 and drag down:

=IF(A1<TODAY(),"Expired Contract","")


--
Regards,
Dave


"Striving for efficiency" wrote:

Is there a function that I can set up to notify me when a contract expires?
I use an Excel spreadsheet to track contracts and insurance certificates and
dates and so on. I was thinking there should be a way to produce a
notification when a certain cell with a date entered expires - make sense?

Thank you

How do I set up a notification for expired items in Excel?
 

I tried to take my arguement further and an error window popped up explaining
too many arguments. I got my cell to come back with "Expired Contract", what
do I add to this formula to come back blank if it is false or if there is no
data?

Thank you!!

"David Billigmeier" wrote:

Check the help menu for an in depth explanation of it, basically:

=IF(condition_you_want_to_test , value_if_true , value_if_false)

--
Regards,
Dave


"Striving for efficiency" wrote:

I never was good with IF statements...can you explain this? I get confussed
with all of the punctuations: () "," thank you

"David Billigmeier" wrote:

If your dates start in A1, put this in B1 and drag down:

=IF(A1<TODAY(),"Expired Contract","")


--
Regards,
Dave


"Striving for efficiency" wrote:

Is there a function that I can set up to notify me when a contract expires?
I use an Excel spreadsheet to track contracts and insurance certificates and
dates and so on. I was thinking there should be a way to produce a
notification when a certain cell with a date entered expires - make sense?

Thank you