Update a date into the same cell?
That looks promising. How would it work for a leap year though?
Thanks a lot
On Sun, 28 Jun 2009 15:13:01 -0700, Sean Timmons
wrote:
If you have a control cell that shows "7/1/2009", then you can do
=IF(today()A2,date(year(A2)+1,month(A2),day(A2 ))-1)
Otherwise, if you want to update the cell based on the actual cell, you're
looking at Macro, which would be better asked within the Programming section
of this group.
"Greg L" wrote:
Is there a way to update a date cell with a new date after the date in
the cell has passed?
ie. I have 7/1/2009 in a cell. After 7/1/2009 has passed, I want it to
display the date that is 364 days past 7/1/2009. This would be
6/30/2010.
I've been trying to figure this out for a while now. Seems simple, but
I must be missing something.
TIA
Greg L
|