| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 76021 | 2007-01-18 00:48:00 | Excel Formula | Happy Harry (321) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 517090 | 2007-01-18 00:48:00 | Hi one and all I am trying to find a way in Excel to keep track of holidays for a small business I believe I have worked this out using a formula based on either 1.25days per month or 0.2884 days per week, but what I would like to happen, is to have the spreadsheet automatically update, using the PCs current date, when the spread sheet is opened. Summing the updated column and then subtracting the used days, will give me the outstanding leave. Any ideas please?? Cheers HH |
Happy Harry (321) | ||
| 517091 | 2007-01-18 01:18:00 | If you use now() in your Excel formula to get the current date, it will recalculate when you open the spreadsheet. | davehartley (3487) | ||
| 517092 | 2007-01-18 01:26:00 | Or use today() to return just the current date without the time. | Ozer (11794) | ||
| 1 | |||||