Working with database and fields defined as date

[NGUIMARAES]

Hi, I created a database with five fields with different format of data:

first - text
second - date (start date)
third - date (end date)
fourth - number

So I want to sum the values of column4, for one value of column1, on day in of month that I choose.

The second and third fields define a period of days.

The problems are applying the formula BDSUM and define table’s criteria.

Thanks,

[tigeravatar]

NGUIMARAES,

Welcome to the forum!
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

[NGUIMARAES]

Hi,


Thank you, next time I'll follow your advise. By the way, I solved my probelm with the formula SUMIFS.

How do I add a file to a post?

[tigeravatar]

From the FAQ:

...To attach a file to a new post, simply click the [Browse] button at the bottom of the post composition page, and locate the file that you want to attach from your local hard drive.