Question about Microsoft Excel for PC
I need an IF formula for an Excel sheet i'm working on. the one i had is =if(a1=''Saturday'',''off'',''''). the problem is, A1 contains =A2 because A2 is a date. I need A1 to show the day for that date. I just want a certain cell to show OFF if it is a certain day. The one I know only works if I put in the day of week manually. Please help.
=weekday(a2) will give you the actual day of the week of the specified date
Posted on Oct 23, 2012
Use the test function.
Formula in cell A1 would be =text(a2,"dddd").
This would pick up the date from cell A2 and return the day of the week in cell A1.
Posted on Jul 22, 2010
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jul 29, 2009 | Computers & Internet
Feb 11, 2009 | Microsoft Excel for PC
Dec 21, 2008 | Microsoft Office Excel 2003 for PC
Sep 15, 2008 | Microsoft Excel for PC
Sep 13, 2008 | Microsoft Computers & Internet
Aug 25, 2008 | Microsoft Office Professional 2007:...
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
88 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: