File a week old? Stop adding to it. Comparing 2 dates.

[spaaw]

what if the data isnt gathered on Saturday and it starts again on Monday, it would save to the same spreadsheet when it would should be saving to a new one.. I think I will need to compare it to the current date somehow, hmm..

thanks

[spaaw]

is there any way to get time difference having only 1 consant?

What i mean is..

I know I will be finishing gathering data on Saturday at midnight.. thats my constant..

now lets say it happens that the program is run on tuesday at X time(this is a variable), can I get the time difference between tuesday and coming Saturday midnight?

thanks

[JÞB]

You can't resolve it to 1.

two parameters:

What was the date last Saturday?

When was the first of the month?

Two discisions in the tree"

Which it closer to now?

Does that file exist or do I need to create it"