Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up date alarms/alerts
I would like to set an alarm/alert that would let me know when a policy date
has expired. It would have to scan/check all the dates in the expiration column. The dates are shown as 3/7/2008 not 35268. I am running Office 2003 sp2. Any help would be greatly appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up date alarms/alerts
Excel dates are stored as numbers. March 7, 2008 is day 39514. Day 35268 is
July 22, 1996. Please explain what you want with a couple of examples. Are the policies expired if their dates are less than today's date? Tyro "fuchsiahop" wrote in message ... I would like to set an alarm/alert that would let me know when a policy date has expired. It would have to scan/check all the dates in the expiration column. The dates are shown as 3/7/2008 not 35268. I am running Office 2003 sp2. Any help would be greatly appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up date alarms/alerts
sounds like all you need is a conditional format, cell value is/less than/
now() turn the cell red or whatever... If you are basing it on the day, and don't want it to change color until the day after, change the now() to roundup(now()) This will check against tomorrow's date. "fuchsiahop" wrote: I would like to set an alarm/alert that would let me know when a policy date has expired. It would have to scan/check all the dates in the expiration column. The dates are shown as 3/7/2008 not 35268. I am running Office 2003 sp2. Any help would be greatly appreciated! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up date alarms/alerts
Does the OP need the time (NOW())? Perhaps. Some policies expire on a given
date at a given time. Or perhaps the OP needs only the date (TODAY()) Tyro "Sean Timmons" wrote in message ... sounds like all you need is a conditional format, cell value is/less than/ now() turn the cell red or whatever... If you are basing it on the day, and don't want it to change color until the day after, change the now() to roundup(now()) This will check against tomorrow's date. "fuchsiahop" wrote: I would like to set an alarm/alert that would let me know when a policy date has expired. It would have to scan/check all the dates in the expiration column. The dates are shown as 3/7/2008 not 35268. I am running Office 2003 sp2. Any help would be greatly appreciated! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up date alarms/alerts
That would be easier if time is not a factor.
"Tyro" wrote: Does the OP need the time (NOW())? Perhaps. Some policies expire on a given date at a given time. Or perhaps the OP needs only the date (TODAY()) Tyro "Sean Timmons" wrote in message ... sounds like all you need is a conditional format, cell value is/less than/ now() turn the cell red or whatever... If you are basing it on the day, and don't want it to change color until the day after, change the now() to roundup(now()) This will check against tomorrow's date. "fuchsiahop" wrote: I would like to set an alarm/alert that would let me know when a policy date has expired. It would have to scan/check all the dates in the expiration column. The dates are shown as 3/7/2008 not 35268. I am running Office 2003 sp2. Any help would be greatly appreciated! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up date alarms/alerts
I would use Conditional Formatting to highlight the dates when they reach a
certain point. Assuming column of dates is column A. Select the range of dates. FormatConditional FormattingFormula is: =$A1=TODAY() Format to a nice color and OK your way out. Note: any text cells will also be colored. If a chance of text being in the column use this. =IF(AND(ISNUMBER(A1)),A1=TODAY()) Gord Dibben MS Excel MVP On Fri, 7 Mar 2008 12:36:02 -0800, fuchsiahop wrote: I would like to set an alarm/alert that would let me know when a policy date has expired. It would have to scan/check all the dates in the expiration column. The dates are shown as 3/7/2008 not 35268. I am running Office 2003 sp2. Any help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up alarms based on days from a specific date? | Excel Worksheet Functions | |||
alerts | Excel Worksheet Functions | |||
time and alarms | Excel Discussion (Misc queries) | |||
Spreadsheet Alarms | Excel Worksheet Functions | |||
Upcoming Date alerts | Excel Worksheet Functions |