Do not display result when cell is empty (date)
Solved
MisSTaelisS
-
MisSTaelisS Posted messages 8 Registration date Status Membre Last intervention -
MisSTaelisS Posted messages 8 Registration date Status Membre Last intervention -
Hello,
How to leave a blank result when the cell of the formula is empty?
Here's my explanation:
I want to get the date J+1 (excluding weekends) and leave the cell blank when no date is provided.
My file looks like this:
Column F => day J
Column G => J+1 excluding weekends
So the formula is: IF(WEEKDAY(F3)=6, F3+3, F3+1)
For example: when F2=10/09/2014 then G2=11/09/2014
when F3=12/09/2014 then G3=15/09/2014 (because the 12th is a Friday and I’m looking for the next working day)
So far so good :)
My problem is that when column F is not filled, a result still shows in the cells of column G: 01/01/1900
I know that the formula/condition to avoid this would be something like: IF(ISBLANK(F3), """,
but I can’t seem to merge those two formulas.... -_-'
I tried: =IF(ISBLANK(F3), """, (WEEKDAY(F3)=6), F3+3, F3+1)
but apparently there is an error that I can’t identify
Can you help me?
I’m using Excel 2003
Thank you
How to leave a blank result when the cell of the formula is empty?
Here's my explanation:
I want to get the date J+1 (excluding weekends) and leave the cell blank when no date is provided.
My file looks like this:
Column F => day J
Column G => J+1 excluding weekends
So the formula is: IF(WEEKDAY(F3)=6, F3+3, F3+1)
For example: when F2=10/09/2014 then G2=11/09/2014
when F3=12/09/2014 then G3=15/09/2014 (because the 12th is a Friday and I’m looking for the next working day)
So far so good :)
My problem is that when column F is not filled, a result still shows in the cells of column G: 01/01/1900
I know that the formula/condition to avoid this would be something like: IF(ISBLANK(F3), """,
but I can’t seem to merge those two formulas.... -_-'
I tried: =IF(ISBLANK(F3), """, (WEEKDAY(F3)=6), F3+3, F3+1)
but apparently there is an error that I can’t identify
Can you help me?
I’m using Excel 2003
Thank you
4 réponses
Hello
missing an IF
=IF(ISBLANK(F3),"",IF(WEEKDAY(F3)=6,F3+3,F3+1))
Best regards
To err is human, to persist is diabolical
missing an IF
=IF(ISBLANK(F3),"",IF(WEEKDAY(F3)=6,F3+3,F3+1))
Best regards
To err is human, to persist is diabolical
Hello,
Just add a conditional
=IF(F3="","",IF(WEEKDAY(F3)=6,F3+3,F3+1))
--
See you+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
Just add a conditional
=IF(F3="","",IF(WEEKDAY(F3)=6,F3+3,F3+1))
--
See you+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.