ExcelBanter - TODAY, Subtract a List of Dates from...

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - TODAY, Subtract a List of Dates from... (https://www.excelbanter.com/excel-discussion-misc-queries/209303-today-subtract-list-dates.html)

DOUG ECKERT[_2_]

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

Mike H

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

DOUG ECKERT[_2_]

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

All times are GMT +1. The time now is 09:14 AM.