IF Function in Excel

S

Superboy

Hello, I want to write an "IF" Formula using dates and blank cells. ie if
Cell A2 is blank, use the date calculated in cell A1. However, if cell A"
has a date, then I want to capture/use that date.

I have tried <>, etc, and it just doesn't like blank cells.

Please help

Thanks
Mehul
 

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

Excel - Wich Function should I use? 1
Display weeks from a Milestone 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
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
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Excel Logical function 5

Top