Formula Assist

A

admin

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.
 
B

Bearacade

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")
 
B

Bearacade

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")
 
T

tony h

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)
 
Top