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


Top