Do not display result when cell is empty (date)

Solved
MisSTaelisS -  
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

4 réponses

Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
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
2
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 146
 
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.
1
MisSTaelisS Posted messages 8 Registration date   Status Membre Last intervention  
 
Thank you for your quick reply.
0
Souafeur Posted messages 223 Status Membre 84
 
Hi!

Try:

=IF(COUNTBLANK(F3)=1,"",IF(WEEKDAY(F3)=6,F3+3,F3+1))

It should work!

Hoping to have helped :)
-1