I am making a workbook that includes timesheets, expense reports, calendars,
master calendar. This is the formula I am doing wrong. In my current cell I
want this information in it: If a certain cell has anything in it (anything
at all), then put the value (it is a date) of this other cell into the
current cell. The point is this, if they mark the "yes" cell on their
calendar saying they have to expense something that day, then on the expense
report I want that date to be auto populated. If you can tell me how to do
this, I can do the rest. Right now the error says '#Value'.

You must give all details to understand members what
kind of problem you have .If you agree , you can send
this wbook to e-mail with
some more details .

I am sending you the workbook. It has been a couple of yrs. since I have set
up interdependent workbooks, so cannot remember how to fix the error.
Thanks!

"ytayta555" wrote:

You must give all details to understand members what
kind of problem you have .If you agree , you can send
this wbook to e-mail with
some more details .

Is the cell you're testing agianst a single, static cell? In other words, if
the current cell is, say, A1 is it always going to look at, say, cell D5?

If so, here's the typical formula I use: =IF(D5<"",D5,"")
Essentially, if cell D5 is greater than or less than nothing (or empty) then
give me what's in it, if it is nothing (or empty) the ""returns an empty cell
(nothing is displayed). If what's in cell D% is formated as a date, you'll
need to manually format the result cell for the proper date format as it will
display the date as ageneral number.

"Paula" wrote:

I am making a workbook that includes timesheets, expense reports, calendars,
master calendar. This is the formula I am doing wrong. In my current cell I
want this information in it: If a certain cell has anything in it (anything
at all), then put the value (it is a date) of this other cell into the
current cell. The point is this, if they mark the "yes" cell on their
calendar saying they have to expense something that day, then on the expense
report I want that date to be auto populated. If you can tell me how to do
this, I can do the rest. Right now the error says '#Value'.