Previous Topic Next Topic

Excel Formulas

Closed
JFB - Sep 25, 2009 at 02:05 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 25, 2009 at 10:32 PM
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
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 25, 2009 at 10:32 PM
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses