Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
How to calculate "number of months" between two given date? | Excel Worksheet Functions | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
calculate the number of days from date received | Excel Worksheet Functions |