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

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.