| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TODAY, Subtract a List of Dates from...
I want a formula to count the remaining dates in the year when subtracted
from TODAY. Hints are welcome - (PLEASE). Dates are in a column and already exclude weekends and federal holidays. DOUG |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TODAY, Subtract a List of Dates from...
Try
=DATE(YEAR(TODAY()),12,31)-TODAY() I don't understand the second bit how can a date exclude dates!! Mike Mike "DOUG ECKERT" wrote: I want a formula to count the remaining dates in the year when subtracted from TODAY. Hints are welcome - (PLEASE). Dates are in a column and already exclude weekends and federal holidays. DOUG |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TODAY, Subtract a List of Dates from...
Mike H: My list excludes those dates which are holidays and weekends. I
want to subtract the number of days remaining in the fiscal year (Oct - Sep) on that list from today's date. Thank you. DOUG "Mike H" wrote: Try =DATE(YEAR(TODAY()),12,31)-TODAY() I don't understand the second bit how can a date exclude dates!! Mike Mike "DOUG ECKERT" wrote: I want a formula to count the remaining dates in the year when subtracted from TODAY. Hints are welcome - (PLEASE). Dates are in a column and already exclude weekends and federal holidays. DOUG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract if dates in the range between 2 dates. | Excel Worksheet Functions | |||
| update cells to today date in a list of dates | Excel Worksheet Functions | |||
| update cells to today date in a list of dates | Excel Worksheet Functions | |||
| Subtract two dates | Excel Discussion (Misc queries) | |||
| Counting Dates less then today | Excel Worksheet Functions | |||
![DOUG ECKERT[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
