Conditional Function not Producing Results

4 divided by 25 divided by 2020
try
=IF(AND(G15=datevalue("4/25/2020"),A16="S&B"),G16,"")

load a sample file
I'm in UK so dates will be different

G15 is a DATE ? and NOT text and it is 25th April 2020
Format G15 -to general - does it stay as a date or change to a number

it produced this value:
1/24/1900 And that is not what is supposed to show. It is supposed to show the value of G16 which is currently 24

1/24/1900 is how Excel will display the number 24 as a date. It looks like Excel is returning 24 just as you expect, but the cell is formatted as date. Change the cell's number formatting to something more appropriate.

you are welcome

yes
use sheetname!
or
'sheet name'!

then cell - whats on a different sheet

cant see the attachment & dont understand the question, sorry

why a word doc and not the spreadsheet excel itself ?????
I dont have to re-create then
Also what results you expect

the attachment does not work -
See the instructions in the yellow banner top of screen

you need to explain a bit more

g4 has a date in of 25th
next in period, what period - why is this 25th based on the info in the sheet?

Short but useless answer -- yes, you can formulate G4 to be the date after the end of a date range.

B3 contains a text string representing the date range. The process would then be:
1) Extract the ending date string (using RIGHT() and maybe a FIND()/SEARCH())
2) Convert the resulting text string to a date serial number (another DATEVALUE() like etaf used in post #2)
3) Then add 1 to it.

I hate dealing with text strings like this. Unless I was told that life, liberty, or national security required us to use only B3 for the date range, I would:
1) Enter the starting date (as a date) in B3
2) Enter the ending date (as a date) in C3
3) G4 then becomes a a simple =C3+1

Attachment failed to attach correctly.

Nope I did not try to attach a file, I was observing that I could not view your attachment in post 20.

Still says invalid attachment.

Jose - follow the instructions in the yellow box at the top of the page to upload your workbook.

I think it will depend on exactly how you are intending to use this workbook. I could see suggesting anything from a manual copy -> paste as values kind of thing (if interact with this sheet rarely) to something that involves redesigning the workbook into a better data base type format (if you need to interact with this sheet frequently). The advantage of copy/paste as values is that you retain all of the "thinking" in your head and the spreadsheet doesn't need to do any of the thinking. The advantage of a good database is that you can then access pivot tables, filters, and many other useful utilities for summarizing and charting the data. It all depends on how you are intending to use this workbook.

I don't do database work, so I don't think I can be much help to you. Some of our regulars are pretty good with databases in Excel, though, and should be able to help design a workable database. Until then, some basic ideas to review:
https://www.excelforum.com/access-ta...ml#post5315969
https://www.excelforum.com/tips-and-...for-excel.html
a couple of links to external pages: https://www.excelforum.com/excel-new...ml#post4906705

I also expect those who come to help will want to know more about how you want to interact with the workbook, what data you need to store, what you will need to do with the data, etc.

deleted -- wrong thread.

If you are considering a database, I would suggest using MS Access. Here is a white paper on how to design and normalize your data.

@josedorkis

29 post just to make clear what you want to achieve.

I hope you follow the forumrules from now on.


First advice, don't work with merged cells you get in trouble with it sooner or later.


Add all data in a verticaly way, like I show you in the sheet Oeldere.

In this case I used VBA code for that.

After that you can use a pivot table to analyse the data.

After that it is also possible to create a graph.

See the attached file.