Need Formula for automatic date update in same cell [Solved/Closed]

Posts
1
Registration date
Friday May 30, 2014
Last seen
May 30, 2014
- May 30, 2014 at 03:51 PM - Latest reply:
Posts
22
Registration date
Sunday May 25, 2014
Last seen
September 25, 2014
- Jun 13, 2014 at 11:56 PM
Hi all,

I was wondering if anyone knew of a formula that would allow excel to change a date in a cell automatically once a certain date had passed?
I have to keep track of when clients at my group home need to have their blood work done. Some have it once a month, some every 3 months etc. Counting days manually for over 100 people is eating all of my time. If I could have a spreadsheet where if I enter the date of their last blood test and then have the formula tell it that they require it again in 30 days but once that day comes and goes, it changes the date to 30 days later.

Is this possible?

Please let me know.

Thank you for your help and time.
See more 

5 replies

Posts
22
Registration date
Sunday May 25, 2014
Last seen
September 25, 2014
- Jun 1, 2014 at 04:48 AM
0
Thank you
Dear

=today() will give you a date of ( now )

let's say one makes a test on ( A1 ) then next test after ( B1 )days you can add the following at C1 :

=IF(TODAY()<B1+A1,"After "&TODAY()-A1-B1,IF(TODAY()=B1+A1,"today "," delay"&A1+B1-TODAY()))

so you can see easily notice what you want by adding conditional format to C cells

I hope this will help other wise let me know
Hi,

THanks for the help. I am not good at excel at all so I am sure it's just me but I can't get cell C1 to work.

I get "After - 40325" and it won't change to date format (which I am sure I do know how to do)
Maybe I am just not understanding conditional formatting.

Can you explain more.
Do I put =TODAY() for A1
and then
=IF(A1<>"", A1+ 14"") for B1 [if let's say I wanted it 14 days later]
and then enter your equation for C1?
Posts
22
Registration date
Sunday May 25, 2014
Last seen
September 25, 2014
- Jun 9, 2014 at 01:55 AM
0
Thank you
Hi,

Dear put data as follows :

put at A1 test date ( any date )---make sure to format A1 as date
put at B1 put number ( interval between two dates )----make sure to format B1 as number
put at C1 the formula =IF(TODAY()<B1+A1,"After "&TODAY()-A1-B1,IF(TODAY()=B1+A1,"today "," delay"&A1+B1-TODAY())) ---make sure to format C1 as General

then C1 will show the status if it is the time or still early or it is over depends on current date

anyway if you put at A1 = Today() that means A1 will keep change every day to current date same issue for B1 then my formula will never works

I hope this will help
0
Thank you
Thank you so much! It works great! I really really appreciate your help.
Posts
22
Registration date
Sunday May 25, 2014
Last seen
September 25, 2014
- Jun 13, 2014 at 11:56 PM
welcome any time