Home » Forums » Open Source Learning Center » Question and Answer

Conditional formulas

Submitted by Evilbite on 18 December, 2012 - 16:25

I am trying to construct a conditional formula to do the following:

Calculate the number of days between 2 dates. If cell A1 (starting date) is blank, then return "0". If cell B1 (end date) is blank then return the number of days between A1 and today's date.

‹ run cmd without using batch on VBA Non-Matching Entries ›
»

Answer for Conditional formulas

Submitted by zinmintdi on 18 December, 2012 - 18:20.

I think it will be ok.

=IF(A1="","0",IF(B1="",TODAY()-A1,B1-A1))

»

Perfect. Thank you!

Submitted by Evilbite on 18 December, 2012 - 20:38.

Perfect. Thank you!

»