Nested IF ??

[Guest]

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.

 

[Jason Morin]

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