Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eán[_2_] Eán[_2_] is offline
external usenet poster
 
Posts: 30
Default Formula

Help please - how do I write a formula that will return the value of one of
two columns of data, for example, column A contains dates and column B
contains some dates, I want column C to return the date in A or if there is a
date in B supercede it with that one?
So, if there is a date in B return that date in C or if B is blank return
the date in A.
Hope this makes sense?
Many thanks
Eán