dates

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

 

[Max]

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

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[puiuluipui]

Thanks max, its working.
Thanks allot!

"Max" a scris:

 

[Max]

Welcome, glad to hear that.