Forum Discussion
XL formula query
I need to calculate the following - appreciate anyones help...!!
Der_Worti thanks for your help but it didn’t work. Tried changing the apostrophe for a comma but that didn’t work either….
CELL("format") returns "G" for default date format CELL function - Microsoft Support
If in column B could be date or nothing, easier way is to check if it is empty or not.
I am interested in providing a reply to this question. Let me do some researches to provide answers to your questions