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'.