help with formula
=if(and(b16date(2006,01,01),b16<2006,06,30),3,if( and(b16date(july
1st),b16<(September 30th),2,etc.
"Franz Verga" wrote:
"Richard" ha scritto nel messaggio
...
If B16 (which is a date) is between January 1st. and June 30th. then 3
If B16 (which is a date) is between July 1st. and September 30th then 2
If B16 (which is a date) is between October 1st. and December 31st. then 0
If B16 5 years then 4
Thanks in advance for any help!!
I don't understand the last if. What do you mean with
If B16 5 years then 4 ?
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|