| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATE as part of a formula
Why doesn't this formula work? =IF(Q11=DATE, P11). Can you not use a date
as part of a calculation or question, and if not, what alternative would be recommended? The idea is: The formula I want is to copy cell P11 into cell R11 if there's text/data(which in this case is a date) in cell Q11. Is there something other than DATE that I could use? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel keeps adding in my date as part of my sum | Excel Discussion (Misc queries) | |||
| Date & Phone Manipulation, Part 2 | Excel Discussion (Misc queries) | |||
| Matching month part of date only | Excel Discussion (Misc queries) | |||
| Extracting Part of a Date | Excel Discussion (Misc queries) | |||
| Look up part of a date | Excel Worksheet Functions | |||
Threaded Mode
