Formula

  • Thread starter Thread starter Eán
  • Start date Start date
E

Eán

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
countifs Function not giving desired result with date criteria 2
Networkdays and misleading results from blank column 3
Help with IF formula 3
if cell is blank then calculate how many days? 4
Determine if a month falls between two dates. 5
Excel Help with dates 2
Lookup 3

Back
Top