View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
v1rt8 v1rt8 is offline
external usenet poster
 
Posts: 34
Default referencing date so you can use A value or B value in a formula

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.