Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another Formula
Ok, this has been a very helpful forum so here goes another.
I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie 22 Aug 09 or blank), and G2 which is the total days between the 2 dates (2 days). The formula below is what gives me the total days, but in F2 without a date, it gives me a negative number. I don't want any number to appear there if F2 is blank. Help =DAYS360(D5,F5,FALSE) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another Formula
Try
=IF(F2,DAYS360(D2,F2,FALSE),"") If this post helps click Yes --------------- Jacob Skaria "Help with cell function" wrote: Ok, this has been a very helpful forum so here goes another. I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie 22 Aug 09 or blank), and G2 which is the total days between the 2 dates (2 days). The formula below is what gives me the total days, but in F2 without a date, it gives me a negative number. I don't want any number to appear there if F2 is blank. Help =DAYS360(D5,F5,FALSE) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another Formula
=IF(F5="","",=DAYS360(D5,F5,FALSE))
-- __________________________________ HTH Bob "Help with cell function" wrote in message ... Ok, this has been a very helpful forum so here goes another. I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie 22 Aug 09 or blank), and G2 which is the total days between the 2 dates (2 days). The formula below is what gives me the total days, but in F2 without a date, it gives me a negative number. I don't want any number to appear there if F2 is blank. Help =DAYS360(D5,F5,FALSE) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another Formula
Hi,
=if(F2="","",DAYS360(D5,F5,FALSE)) if this helps please click yes, thanks "Help with cell function" wrote: Ok, this has been a very helpful forum so here goes another. I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie 22 Aug 09 or blank), and G2 which is the total days between the 2 dates (2 days). The formula below is what gives me the total days, but in F2 without a date, it gives me a negative number. I don't want any number to appear there if F2 is blank. Help =DAYS360(D5,F5,FALSE) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|