Blank cell if data if not entered

[uab_00]

Hi All

want to keep the cell blank if the data is not entered in a cell(B6) and at the same time I want to subtract from cell(b6) 14 days?the

I put the below but it does not work, the date is placed in b6

=IF(B6="","",B6-14,B6+choose(weekday(B6),1,0,0,0,0,0,2))
Thanks

 

[Fishboy]

Hi All

want to keep the cell blank if the data is not entered in a cell(B6) and at the same time I want to subtract from cell(b6) 14 days?the

I put the below but it does not work, the date is placed in b6

=IF(B6="","",B6-14,B6+choose(weekday(B6),1,0,0,0,0,0,2))
Thanks

Hi uab_00,

Does this work for you?

=IF(B6<>"",B6-14,"")

 

[uab_00]

Thanks

 

[Fishboy]

Thanks

Happy to help

 

[uab_00]

And what about if the date follow during a bank holidays?

 

[Fishboy]

And what about if the date follow during a bank holidays?

Hmm, I am not too sure about that I am afraid.