This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello! I'm having problems with the formulas as it is not working and not showing the value after entering the correct equation. I'm putting the right equation but I'm still getting a red dotted lines around the box cell or sometimes it is just showing the equation I have typed without any result.
Hope to get a reply as soon as possible. Thank you!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
There is nothing wrong with your formula. As for the red dotted line around the cell, I'm haven't seen that before. As for the cell displaying the formula - that suggests the cell with the formula is formatted as text. In that case you should reformat the cell to something like number and then reenter the formula.
Answer accepted by question author
Sorry, I wasn't able to recreate your problem. I was able to get both forms of the formula to work, both subtracting 1 after weekday() conversion, or as I suggested below, as part of the function.
the weekday function returns a number for the day of week
For example using 2021-01-01 returns number 6.
If you want to get the previous day, subtract the number from the date before using the function
=weekday(a1-1,1)
One thing I noticed is that both online and desktop version tended to convert the number to date format, outputing junk. After the first calculation I had to convert the cell back from date format to general or integer.
It's in excel online. Formula or equation like this one =weekday(B3,1) - I have typed this in excel and then the box cell had red dotted lines around it and sometimes when I type a formula nothing changes at all, all I see is the formula on the cell.
Hi Simarjit,
Did you refer to above replies?
Best regards,
Jazlyn
What application? Excel? Word?
.
What formula / equation?
What is the expected result