Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
HELP!!! I have a formula that will tell me how many items are open with a
date in the past what I need now is one that will also tell me how many open items will be coming up in the next two weeks and one for anything over two weeks€¦. Any help would be greatly appreciated. Thanks in advance. =SUMPRODUCT(--(F2:F13TODAY()),--(G2:G13="Open")) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ADD WEEKS TO A DATE | New Users to Excel | |||
Summing by weeks | Excel Worksheet Functions | |||
Weeks and dates | Excel Worksheet Functions | |||
Counting weeks | Excel Worksheet Functions | |||
calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions |