| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert date in formula
Hello,
I have a column of start dates and another column to figure out the number of days between start date and the end of the year. The formula I want to enter is =31 Dec 2008 - Start date This will give me the number of billable days in 2008. I can populate this data by putting 31-dec-2008 in a cell and referring to it. However, is there anyway to put this date in the formula itself? Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
| insert date | Excel Worksheet Functions | |||
| Insert new date once. | Excel Worksheet Functions | |||
| HOW TO CREATE A FORMULA TO AUTOMATICALLY INSERT THE DATE | Excel Discussion (Misc queries) | |||
| Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
Threaded Mode
