fields that containa formula need to appear blank until data entered

**Newport Count** · 06-10-2009, 10:44 AM

Hi,

i have two date fields....one date requested eg 02/06/09 (cell C10)...another date completed eg 03/06/09 (cell R10)

a third field (cell S10) contains the formula: =IF(R10-C10=0,"less than a day",R10-C10)

so if a request was actioned on the day then it shows as less than a day, otherwise will show how many days it took

but when this formula is draggeddown all other cells show - less than a day

how can i make these cells blank whilst still holding the formula?

also - is there a quick formula to add to show only the amount of wrking days a request took to complete?

Many thanks

**NBVC** · 06-10-2009, 10:46 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**NBVC** · 06-10-2009, 10:54 AM

Thanks for taking the time to read and comply with the rule

.

Try:

=IF(OR(R10="",C10=""),"",IF(R10-C10=0,"less than a day",NETWORKDAYS(C10,R10)))

NETWORKDAYS is an Analysis Toolpak Function... Tools|Addins >> Analysis Toolpak

**Newport Count** · 06-10-2009, 11:04 AM

thanks - it works but the cells that contain that formula now have a blue outline?

**NBVC** · 06-10-2009, 11:08 AM

Looks like you have formatting around it... simply entering a formula does not place blue borders around a cell... Go to Format|Cells and check the Borders tab...

**Newport Count** · 06-10-2009, 11:12 AM

yes every other formula i have entered has never given me blue borders!

problem resolved thanks

**Newport Count** · 06-10-2009, 11:21 AM

=IF(OR(R10="",C10=""),"",IF(R10-C10=0,"less than a day",NETWORKDAYS(C10,R10)))

using this formula......if requested on 02/06/09 and request completed on 02/06/09 then = 0 working days (less than a day)

but if requested on 02/06/09 and request completed on 03/06/09 then = 2 working days - and not 1?