Thread: Nested IF ??
View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

I'm a little unclear. If Free Try = "no", then calculate
the number of days from the start date to the end of the
month? If so, try:

=IF(B3="no",DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-A3,"")

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to handle the following billing scenario. My

data is like so:

Start Date Free Try

12/6/2004 no
12/15/2004 yes

I would like to place a formula in column c that will

tell me how many
business days of billing for the month the customer

should be assigned.

Thank you in advance.
.