dates

P

puiuluipui

Hy, i need to write a date and the formula to show me the day.

Example:

a b
1 11.06.2008 monday
2 06.06.2008 friday
3 saturday !!!!!problem

The formula is in "b" cell. I use this formula and its working but if i dont
write anything in cell "a", the formula show me "saturday". I dont want
anything to show in "b" cell unless i write something in "a" cell.

Thanks in advance.
 
M

Max

Maybe just attach a simple front IF check, like this:
In B1: =IF(A1="","",<your formula>)
 
S

Sandy Mann

Assuming that your dates are real dates (ie like 11/6/2008 not with decimal
points) then in B1 enter:

=IF(A1="","",A1)

and Custom format as dddd

then copy down using the fill handle

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top