excel 2003

[Jennifer Clarke]

I have created a spreadsheet with column A incoming date B amount of weeks Column C Finish date and column d is the current date (today())
I need to be able to turn off the current date once the finish date has occurred excel 2003

 

[Aladin Akyurek]

Try...

D2:

=IF(ISNUMBER(C2),"",TODAY())

 

[VoG]

Perhaps in D1 copied down


=IF(TODAY() < C1,TODAY(),"")<c1,today(),"")>

<c1,today(),"")></c1,today(),"")></c1,today(),"")>

 

[Jennifer Clarke]

I need to turn off the date once column C date has occurred, I tried the formula but it did not work

Column A- Has Referral Date
Column B- Has the amount of weeks they need care (A2+(B2)*7
Column C- Has the discharge date (A&B give the discharge date)
Column D- Has today date (Today())
Column E- Amount of days for care left(C2-D2)
I need to display the current date each day the client is in care, but when there discharge date comes around I need the date to stop in Column D, this will show the correct day the client care is completed.

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=64 height=20></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>(</TD></TR></TBODY></TABLE>