Date = Information
On my workbook, I have a 7 day Mon-Sun Schedule.
Each week, the dates change accordingly.
My question is..
Is there a way, that, depending on the date, if a specific date shows up, information will be displayed in some cells.
Say..
On the last day of this month, October 31st, is Inventory.
When that particular date shows, the cells will display information like: "Remember, Inventory is today.
Schedule your shifts accordingly."
Would it be possible to have a Sheet dedicated to Each day of the week, and we can edit each day with different reminders.
That flow over to where it needs to be displayed.
Keys to the Problem Date = Information
Download SmartPCFixer for Free Now
Hello,
If the schedule shows real dates, then you can set up a separate sheet in the workbook.
Let's say that sheet is called "Reminders".
Column A has the dates for 1st-January through to 31st-December.
Column B has the info text you would like to display for
that date.
Not every row has a text in column B.
In the Schedule sheet you can then use a lookup formula to pull the text for each of the 7 displayed dates.
If the dates are in A1 to G1, you can use a formula like this in A2 to G2
=iferror(vlookup(A1,Reminders!$A$1:$$366,2,false),"")
Copy across to G2.
Adjust the cell references to suit your layout.
cheers, teylyn
To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.
Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.
Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.
Another Safe way to Repair the Problem: Date = Information:
How to Fix Date = Information with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your system. The junk files will be shown in the list.
2. After the scan is done, you can see the errors and problems which need to be fixed.
3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.
Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 2.6.23.40059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.7.62.0.50 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.8.0.2.3,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: Troubleshoot:Dell photo AIO printer 994 does not work on windows 8 Error,Fast Solution to Error: Deleting data from one sheet based on criteria\/data from a separate sheet,Troubleshooting:Data Validation & lookup Error,Data on a USB stick still accessible after removal of USB stick! Tech Support,Solution to Error: Defrag Stuck at 1% No Matter How Many Time I Run It
No comments:
Post a Comment