Search : in
By :

Excel Formulas

Last answer on Sep 26, 2009 3:32:08 am BST JFB, on Sep 25, 2009 7:05:17 am BST 
 Report this message to moderators

Hello,

I am trying to do an "if" statement between two dates to calculate which VAT qtr i am in
example

vat amount in colum e
date paid in colum g
What i want to say is that if the amount is paid in a specific vat quarter i.e. 1/06/09 to 31/08/09 enter the wording in column h3 being qtr2

can anyone help with a formula

I am using office 2007 excel

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Excel Formulas » in :
Basic Excel Formulas Show Basic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Basic Excel Formulas 2 Show Basic Excel Formulas 2 We saw the SI function Function and is also interesting. Combined with SI, this gives: = IF (AND (condition1; condition2 ;....... conditionZ) true false) displays on the various conditions to be verified (eg...
Excel formula to get the cell with the text Show
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

 venkat1926, on Sep 26, 2009 3:32:08 am BST

Try something like this (modify to suit you)

=IF(AND(A1>="5/1/08"+0,A1<="5/10/09"+0),1,2)

that +0 is important

   
Reply to venkat1926
Ask your question Reply
They need your help