3 ms·
The following formula will return the closest moon phase emoji in Excel: =LET(phase,MOD(ROUND(MOD(NOW(),29.5275)/3.691,0)-2,8)+1,UNICHAR(127760+phase)))
by robsh 2y ago
The following formula will return the closest moon phase emoji in Excel:
=LET(phase,MOD(ROUND(MOD(NOW(),29.5275)/3.691,0)-2,8)+1,UNICHAR(127760+phase)))