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
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
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:
- Excel Formulas
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Date formula in excel dd/mm/yyyy - Guide
- Excel spreadsheet formulas - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 25, 2009 at 10:32 PM
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
=IF(AND(A1>="5/1/08"+0,A1<="5/10/09"+0),1,2)
that +0 is important
