Calculate a date or key a date on condition
 

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 be
manually
keyed in.

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

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


--
Tolo
------------------------------------------------------------------------
Tolo's Profile: http://www.excelforum.com/member.php...o&userid=35368
View this thread: http://www.excelforum.com/showthread...hreadid=551404

Calculate a date or key a date on condition
 

=if(B1="",A1+10,"overtype with actual invoice date please")

try that...


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=551404

Calculate a date or key a date on condition
 

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


--
Tolo
------------------------------------------------------------------------
Tolo's Profile: http://www.excelforum.com/member.php...o&userid=35368
View this thread: http://www.excelforum.com/showthread...hreadid=551404