Stuck and getting frustrated. Can you assist

[Guest]

Pretty new to all this but hopefully this will make sense.

Have a worksheet 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]

You shouldn't need today's day in every row. Enter it once on the
worksheet, 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.

 

[Guest]

If you don't want to change what you already have, try this:

Column A is the date you're entering
Column B formula =IF(ISBLANK(A1),"",TODAY())
Column C is =IF(ISBLANK(A1),"",B1-A1) with column 'C' formated as a number.
Copy the fomulas down as far as required.