Thread: Display a value between certain dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peterp Peterp is offline
external usenet poster
  
Posts: 7
Default Display a value between certain dates
Hi
If dates are in A1:A100.
I want to place a value in B1:B100.
IE: all dates between 1 Feb07 and 28feb07 I would like to see a "1" in
B1:B100.
All dates between 1Mar07 and 31Mar07 a "2" etc.
I have tried various "IF" fomulae but none of then work.
Any suggestions would be appreciated.
Reply With QuoteReply With Quote