Norman Frederick wrote:
Can this be done? Will it require a formula or an executable
script(which I do not yet know how to write)?
Any and all suggestions will be greatly appreciated.
I will learn!
Fred
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
First of all, you have column D being both a date and a dollar
amount. So let's assume that you meant that column E is the dollar
amount.
You are correct. I goofed. C& E are dates, D & f are numbers.
If C and D are both in date format then you should be able to do it
like this:
In cell Gn:
=if(Dn-Cn<365,sum(En-Fn),)
In cell Hn:
=if(Dn-Cn<365,,sum(En-Fn))
There may be a better way. But I think that this will do what you want.
I cannot make this way work. I have tried using datedif to get the
number of days but I do not get what I need (nor anything else). Is <
a valid less than symbol? I have tried both < and -lt and a window
pops up with both saying everything must be valid references.
I need to go back to school and refresh my math and programming, but
sweetthing says I am to old. Eighty-one ian't old!