LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Formula help needed


The reply I received suggested this formula...
=IF(COUNT(C1:D1),MAX(C1+90,D1+60),"")
Many thanks and I carefully tried it but did not completely work.
Maybe I confused the issue...
In column C, if there is a date in C1 or C2 or C3 or C4 and on down say thru
C30, I wish to add 90 days & have the date put in the corresponding E cell,
ie C20 answer in E20.

In column D, if there is a date in D1 or D2 or D3 or D4 and on down say thru
D30, I wish to add 60 days & have the date put in the corresponding E cell.

There would not be a date in C1 and D1 at the same time.
MANY MANY thanks for your help
David
This is a spreadsheet where we would enter a date in either C Or D column
vertically and have it automatically calculate the forward date in E column.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
needed formula Mikey[_2_] Excel Worksheet Functions 4 December 19th 07 12:56 AM
Formula Set Up Needed unique Charts and Charting in Excel 2 December 4th 05 10:24 PM
= if formula needed WYN Excel Discussion (Misc queries) 5 September 5th 05 11:04 PM
Formula needed audi Excel Discussion (Misc queries) 4 August 3rd 05 12:09 PM
Formula needed Connie Martin Excel Worksheet Functions 22 November 9th 04 03:43 PM


All times are GMT +1. The time now is 11:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"