Help with date formula

C

Clare

Hi

Atishoo very kindly helped me with the formula below which works great,
however, if there is no date in column V4 then the date 13-Feb-00 shows in
the column where the formula is. Could someone please help with this so that
column is blank if there is no date in column V4. I thought it would be
something like =IF(v4,"","", but not sure where about in the formula it
should be placed or even if this is right.

=IF(WEEKDAY(V4,2)<4,V4+43-(WEEKDAY(V4,2)),V4+50-(WEEKDAY(V4,2)))

Hope you can help me with this.

Cheers
 
M

Mike H

Clare,

=IF(ISNUMBER(V4),IF(WEEKDAY(V4,2)<4,V4+43-(WEEKDAY(V4,2)),V4+50-(WEEKDAY(V4,2))),"")

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

showing zero in cell 5
Percentage Breakdown Formula Help? 5
Counting a mixed text/number column based on text in another colum 3
Salary by Qtr Formula 1
SUMPRODUCT Problem 2
Pivot Table? ID, Date, Value sorting 4
Show blank or zero 1
Working out a future date with formulas 3

Top