Formula Assist
 

I am trying to come up with a formula or macro that would take a column
of various dates and compare the amount of days between each date and
the current date. If the amount of days for any of those cells is =|
183 give me a count of the number of cell that meet this parameter. Not
sure where to start with this one any help would be greatly appreciated.

Formula Assist
 

Assuming Column A is your dates,
Put this in Colum B, =Today()-A1
make sure Column B is formated General

then put =COUNTIF(B:B, "183")


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=549223

Formula Assist
 

Assuming Column A is your dates,
Put this in Colum B, =Today()-A1
make sure Column B is formated General

then put =COUNTIF(B:B, "183")


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=549223

Formula Assist
 

To get the number of days difference you just need to subtract one date
from another. then use a countif to get the total you want.

if you only want weekdays use networkdays(date1,date2)


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=549223