| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Open file if cell date is less than today+30 day?
Hi all,
I have had many answers from here from others, but now one new came up. I have a file which has about 540 rows and 15 colums. In cell H4 =(today) and i4 is time in days (30). So far we have been operating with conditional formatting so if next check date is in next month we give orders to our maintenance. In col A is mahines ID, B is name etc and col H is next maintenance date. Purpose would be that if next maintenance should be in 30 days (or 14, we haven't decided yet) this file would open first thing in morning. But is it possible to do opening just for certain people? This file is in our server... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| go to cell with date equaling TODAY() | Excel Discussion (Misc queries) | |||
| Open an Excel file with a date as today in a macro | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
