Re: Stuck and getting frustrated. Can you assist

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 01/30/05 

Date: Sun, 30 Jan 2005 09:16:05 -0500

You shouldn't need today's day in every row. Enter it once on the
work***, then refer to that cell in column C.

For example, in cell E1, type: =TODAY()
In cell C2, type: =IF(A2="","",$E$1-A2)
Copy that formula down as far as required.

Andy S wrote:
> Pretty new to all this but hopefully this will make sense.
>
> Have a work*** which monitors people attendance on a course. A1 is the
> date they commenced. B1 auto defaults to todays date. C1 is the total number
> of days completed since their commencement. D1 is the percentage completed
> for the year.
>
> The problem is i want the default todays date (B1) only to be entered if the
> inputter has inputted a commencement date. If A1 is blank then then I want B1
> to remain blank instead of defaulting to todays date. So... when they enter a
> commencement date then B1 automatically defaults to todays date.
>
> I'm happy with the other formulas involved. I just need to know how to keep
> B1 blank and stop it going to the default unless a commencement date is
> entered
>
> Hope I haven't confused you any more than I am already.
>
> Andy 

-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Quantcast