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.
.
|