Calculate a date or key a date on condition

T

Tolo

A1 = Ship date
B1 = Invoice number
C1 = Invoice date

Given that: 1. The Ship date in A1 will be manually keyed in.
2. The invoice number in B1 will be blank or will b
manually
keyed in.

What I want to do: 1. If the invoive number in B1 is not blank I wan
to
manually key the actual invoice dat
into C1.

2. If the invoive number in B1 is blank
want to add 10
to the ship date in A1 to give
projected invoice date
in C
 
T

Tolo

That works but ounce you type in a date the formula is replaced. You ge
one shot at it. I need to cycle through it several times
 
Top