View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dungan dan dungan is offline
external usenet poster
 
Posts: 411
Default How to use date for calculating values in other cells

On Oct 17, 10:03*am, Bamboozled
wrote:
I want to include the date in the "If" statement for calculating values in
other cells.
Example: *If the start date is after 1/1/1999, then A-B. *


If the start date is in c1, would this work?

=if(c11/1/1999,a1-b1,"")