View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Laura Logan Laura Logan is offline
external usenet poster
 
Posts: 3
Default If Function and Dates

I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column c1
falls between those dates, I want to have the cell in D1 enter the value of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura