Blog Post

Excel Blog
6 MIN READ

Advanced Formula Environment is becoming Excel Labs, a Microsoft Garage Project!

petraronald's avatar
petraronald
Icon for Microsoft rankMicrosoft
Apr 11, 2023
Experimentation is key to unlocking innovation in any field. It’s how we learn and grow, and it’s what helps us continue to create features that help you do more.   So today, we are thrilled to a...
Updated Apr 11, 2023
Version 1.0
Excel
mtarler's avatar
mtarler
Silver Contributor
Apr 13, 2023

Wow this is really exciting.   I asked it to write me a lambda function to compare 2 date ranges to see if they overlap, here is the result:

 

at least logically right, now to get Excel LAMBDA functions in there ....  Very cool (BTW I added "EXCEL" before lambda in the request and got a valid excel IF() formula to do the comparison so pretty close.