LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Conditional formula for dates

I'm looking for help with a conditional formula.

A B C D
1 11/1/09 z

I'd like a formula in column B to calculate days depending on columns A and
D. If column D is "z", i'd like to add 10 days to column A. If column D is
"y", I'd like to add 20 days to column A.

Thanks for any assistance!
 
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
Conditional formula to highlight dates (and that entire row) Shane Devenshire[_2_] Excel Worksheet Functions 0 June 8th 09 09:41 PM
conditional formula based on dates filups[_2_] Excel Worksheet Functions 4 November 30th 08 01:38 AM
formula in conditional formatting with dates MelB Excel Discussion (Misc queries) 3 November 16th 07 01:41 AM
Conditional formatting formula for past due dates Annabelle Excel Discussion (Misc queries) 1 July 18th 07 04:28 PM
Conditional formatting with dates formula problem. [email protected] Excel Discussion (Misc queries) 8 March 5th 05 11:47 PM


All times are GMT +1. The time now is 10:33 PM.

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"