Thread: Date Math
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
metaltecks metaltecks is offline
external usenet poster
 
Posts: 22
Default Date Math

I have 2 columns, ADM and DISC. These are both date fields in the format of
6/20/2006.

In a column next to these 2 columns, I want to create a formula that will
check the difference between the 2 dates. If the date difference reaches 30
days, I would like for it to place a 1 in there, otherwise, nothing. I've had
problems trying to create the if statement, but have had no sucess in doing
it...can someone help me.

Thank you