Sep 22, 2023
Excel formula not working in google sheets.
=TEXT(WEEKDAY(DATE($AG$1,11,B3),1),"aaa")
this is referencing cell ag1 for the year and then populating day of week based on day number in b3 and month"11". only displays "aaa" in google sheet with this formula.
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
I don't use Microssoft Excel so I can't speak for it.
Google Sheets and Microsoft Excel are developed by two different companies so there are going to be differences.
There are cases where functions will work directly and other cases where they won't.
Only users experienced in both platforms will know what the differences are and know how to deal with them.
At a guess, it might be that "aaa" in Excell means avriviation.
In Google Sheets "ddd" means short day name and "dddd" means long day name.
Ben Liebrand
When you've received a response that answers your question, please observe these forum courtesies;
• Leave your demo sheet shared as part of this solution's archive,
• Click Recommend on the post that best addressed your question, and
• Post again soon!
Original Poster Brian Gleich marked this as an answer
Hi, Brian Gleich,
Is this what you are trying to do
=TEXT(WEEKDAY(DATE($AG$1,11,B3),1),"ddd")
If not, please share an example mockup spreadsheet so we have a better idea what you are trying to do.
Ben Liebrand
Original Poster Brian Gleich marked this as an answer
All Replies
Hi, Brian Gleich,
Is this what you are trying to do
=TEXT(WEEKDAY(DATE($AG$1,11,B3),1),"ddd")
If not, please share an example mockup spreadsheet so we have a better idea what you are trying to do.
Ben Liebrand
Original Poster Brian Gleich marked this as an answer
Sep 22, 2023
I don't use Microssoft Excel so I can't speak for it.
Google Sheets and Microsoft Excel are developed by two different companies so there are going to be differences.
There are cases where functions will work directly and other cases where they won't.
Only users experienced in both platforms will know what the differences are and know how to deal with them.
At a guess, it might be that "aaa" in Excell means avriviation.
In Google Sheets "ddd" means short day name and "dddd" means long day name.
Ben Liebrand
When you've received a response that answers your question, please observe these forum courtesies;
• Leave your demo sheet shared as part of this solution's archive,
• Click Recommend on the post that best addressed your question, and
• Post again soon!
Original Poster Brian Gleich marked this as an answer
It is always a good idea to check the documentation for functions on each platform so you can be aware of the differences if any.
Ben Liebrand