Sheelo, thank you for the interest.
Based on the date in cell H1 that has the formula =today(),
cell H2 is where i need a formula for the following:
Date ranges are from (May 1 - Oct 31) if cell H1 falls between these dates
then the result in cell H2 displays 184. however if the date in cell H1 is
between (Nov 1 - Apr 30) then the result in cell H2 displays 189. is there
also something else i would need to change the cell H1 as far as formating.
the numbers displayed are used later on in the spreadsheet.


"Sheeloo" wrote:

Problem not clear. Can you provide few rows of data and the result you want?

"v1rt8" wrote:

two date ranges (may 1 thru oct 31)(nov 1 thur apr 30). depending on the date
there is a different value giving. example, its sept 8 and the value i need
is 184.
If it was dec 25, the value i would need is 189. all of this needs to
reference the date which i used in a different cell using =(today)).
any help would be appreciated.