Forum Discussion
Announcing the general availability of the Microsoft Excel API to expand the power of Office 365
Today, we are pleased to announce the general availability of the Microsoft Excel REST API for Office 365—now developers can use Excel to power custom apps. Excel is an indispensable productivity too...
Hi Lana,
That sounds impressive. Kindly assist me with a formula that will return a date in one cell from two cells depending on which cell is filled.
For instance, a date should be returned in Sheet2 A7 from sheet1 A1 if sheet1 A4 is empty (no date filled) or from sheet1 A4 if sheet1 A1 is empty(no date filled) else return an empty cell if both (Sheet1 A1 and A4) are empty.
Thank you.
That sounds impressive. Kindly assist me with a formula that will return a date in one cell from two cells depending on which cell is filled.
For instance, a date should be returned in Sheet2 A7 from sheet1 A1 if sheet1 A4 is empty (no date filled) or from sheet1 A4 if sheet1 A1 is empty(no date filled) else return an empty cell if both (Sheet1 A1 and A4) are empty.
Thank you.