Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More date/counting functions
I need G2 to start counting DOWN when F2 is 150 days out from TODAY's date
F G H 1 Exp. Date Req Due to Terminal Request Rec'd 2 10/31/08 -99 07/21/08 and then stop counting when H2 gets populated with a date (in theory, the requests will come in way before F2's dates, such as in the above instance) of course, with making sure G2 stays blank if: 1. F2 is blank AND 2. F2 is more than 150 days from TODAY Is this even possible?! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More date/counting functions
Hi,
See if this works for you =IF(OR(F2="",F2TODAY()+150),"",IF(H2<"",H2-F2,F2-TODAY())) Also I don't understand you sample numbers, I would expect G2 to be -102? If this post is helps please click Yes. -- Thanks, Shane Devenshire "HeatherBelle" wrote: I need G2 to start counting DOWN when F2 is 150 days out from TODAY's date F G H 1 Exp. Date Req Due to Terminal Request Rec'd 2 10/31/08 -99 07/21/08 and then stop counting when H2 gets populated with a date (in theory, the requests will come in way before F2's dates, such as in the above instance) of course, with making sure G2 stays blank if: 1. F2 is blank AND 2. F2 is more than 150 days from TODAY Is this even possible?! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More date/counting functions
Works perfectly!! You rock my world!!
I had something started that looks similar, but I'm not used to thinking this way nor am I familiar with what all my options are in Excel (though I LOVE learning new things like this)... I'm an English major! HAHA "ShaneDevenshire" wrote: Hi, See if this works for you =IF(OR(F2="",F2TODAY()+150),"",IF(H2<"",H2-F2,F2-TODAY())) Also I don't understand you sample numbers, I would expect G2 to be -102? If this post is helps please click Yes. -- Thanks, Shane Devenshire "HeatherBelle" wrote: I need G2 to start counting DOWN when F2 is 150 days out from TODAY's date F G H 1 Exp. Date Req Due to Terminal Request Rec'd 2 10/31/08 -99 07/21/08 and then stop counting when H2 gets populated with a date (in theory, the requests will come in way before F2's dates, such as in the above instance) of course, with making sure G2 stays blank if: 1. F2 is blank AND 2. F2 is more than 150 days from TODAY Is this even possible?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions- Finding and counting specified text in cell range | Excel Worksheet Functions | |||
counting functions | Excel Worksheet Functions | |||
Counting Functions | Excel Worksheet Functions | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
counting functions | Excel Worksheet Functions |