Previous Topic Next Topic

Community help with excel

Closed
mulchara - Jun 17, 2010 at 12:57 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 17, 2010 at 10:27 AM
Hello,

I want a formula to select a certain sel if today's date falls between a date range. For example: today's dat is 16/6/2010 and if falls between 1/7/2009 and 1/7/2010 thus the answer should be 30

1/7/2008 10
1/7/2009 20
1/7/2010 30
1/7/2011 40
1/7/2012 50
1/7/2013 60


Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 17, 2010 at 10:27 AM
Lets assume that the date that you are checking for is in C1 and dates other wise are in A and numbers in B then


=INDIRECT("B" & IF(ISERROR(MATCH(C1,A:A,0)),MATCH(C1,A:A)+1,MATCH(C1,A:A,0)))


Note: I just corrected the formula

Similar discussions

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

11 responses
Your comment goes against our Community Standards on spam
9825713374 -
HelpiOS -

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

6 responses