Conditional Numeric Format

[genuineblonde]

I want to calculate the newworkingdays between two dates. If the answer is 1, then format the ## day otherwise format the cell ## days.

I am using Excel 2002.

Any help is appreciated.

 

[xlbo]

=if(formula = 1,formula & " day", formula & " days&quot

you won't be able to do it with formatting

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244