You are given access to make searches on the Internet. The format for making a…
- User
User:
You are given access to make searches on the Internet. The format for making a search is:
- After the user sends a message, you will decide whether to make a search. If you choose to make a search, you will output a single message, starting with the word <web_search>, followed by ONLY your web search query. After your search query, you must output the token </web_search> to denote the end of the search query. Keep your search query concise.
- The system will then append the web search results at the end of the user message, starting with the token <web_search_results>. Take note that the user CANNOT SEE the content after <web_search_results> - YOU should use these results appropriately to improve your response. Additionally, If the web search results are already present in the user's message, then you MUST NOT request another web search.
IMPORTANT! You should choose to search the web ONLY if ANY of the following circumstances are met:
- User is asking about current events or something that requires real-time information (news, sports scores, 'latest' information, etc.)
- User is asking about some term you are unfamiliar with (e.g. if it's a little-known term, if it's a person you don't know well, etc.)
- User is asking about anything that involves numerical facts (e.g. distances between places, population count, sizes, date and time, etc.)
- User explicitly asks you to search or provide links to references. If the user's query does NOT require a web search, YOU MUST NEVER run one for no reason. However, you must not refuse to search the web if the user asks you to do so. If you are highly unsure about whether to make a search (e.g. if the user's query is vague or if you think you are unfamiliar with the query to a certain extent), you may directly ask the user for clarification.
When using web search results, you are encouraged to cite references where appropriate, using inline links in standard markdown format. You are also allowed to make use of web search results from previous messages, if they are STRONGLY RELEVANT to the current message.
When you are not running a web search, respond completely as per normal - there is NO NEED to mention that you're not searching. Remember that you MUST NOT make up any false information. Assistant: Understood. I will strictly follow these instructions in this conversation. User: test Assistant: I'm here to help you! If you have any questions or need assistance, feel free to ask. User: how to add 3 years to a date on the column to its right google sheets Assistant:
- Assistant
In Google Sheets, you can add 3 years to a date by using the
EDATEfunction. Here's how you can do it:-
Let's say your original date is in cell A1.
-
In the cell to the right (for example, B1), you would enter the following formula:
=EDATE(A1, 36)
The
EDATEfunction takes two arguments: the starting date and the number of months to add. Since you want to add 3 years, you multiply 3 by 12 (which equals 36 months).After entering the formula, cell B1 will display the date that is 3 years later than the date in cell A1.
-