Cell reference must work with formula output, not formula itself
In a timesheet, I want the result of a formula to depend on the value of a referenced cell, not the formula itself. To clean up my timesheet, I want Excel to leave the cell "hours/day" blank if that day is either Saturday or Sunday.
Column B has the date in format dd/mm/yyyy
Column A shows the day of the week (in Dutch) Monday, Tuesday, etc. (abbreviated).
Column C has the time I started working,
Column D shows the time I finished working.
Column E has the amount of time I took for lunch.
Column F has this formula:
However, even though A4 displays 'za' (the Dutch equivalent for 'Sat') it still does not display a blank cell. I suspect the reason is because my formula refers to the relative value of cell A4, not the absolute value (the result of the formula in A4, rather than the formula itself).
How can I make sure that for Saturdays and Sundays the fields are left blank?
Re: Cell reference must work with formula output, not formula itself
You have to use Text function.
Try something like this.
ddd format of a date, gives you "Sat" if date is Saturday like 18/08/2012 for example...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1