Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help :-(
Hi
I am quite new to excel's more advanced formulas. What I currently have on my table is: A cell that contains the formula =TODAY() This cell is working and returns todays day eg Wednesday used cell properties to change its form no problem there I also have within the sheet a table that contains days on which an item is to be ordered also in the form of text eg Wednesday. My final colum is a To be ordered whihc i wanted it to compare the value from the =TODAY() formula and compare it with the day in the order day cell and return true if they match or false if they don't I tried this formula but it doesn't work can anyone help me thanks =EXACT(J7,$B$1) J7 = the days to be ordered in text form B1 = Formula containing =TODAY() Hope that makes sence thanks Katy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |