Help with date formula
 

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
--
Clare

Help with date formula
 

Clare,

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

Mike

"Clare" wrote:

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
--
Clare

Help with date formula
 

Thanks Mike

Works great

Cheers
--
Clare


"Mike H" wrote:

Clare,

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

Mike

"Clare" wrote:

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
--
Clare