| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Calculation from a Due Date
On Tue, 29 Nov 2005 13:52:02 -0800, Prabha
wrote: Hi all, I have a project table with due date in cell A4. In cell A5, I require to have it calculate, the number of days/months remaining till the Due Date. I haven't been able to find the answer by Googling. There are solutions for calculations between 2 dates and so on. Your advise would be very much appreciated, as I require to prepared this by the end of this week. Many thanks in advance. Prabha A5: =A4-TODAY() will give the number of days remaining from today until the due date. Format A5 as General (Format/Cells/Number/General) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A specific date used for calculation of a new date | Excel Discussion (Misc queries) | |||
| Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend? | Excel Programming | |||
Threaded Mode
