Need Formula for automatic date update in same cellSolved/Closed

Question

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.

Osama_bb11 · Answer

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

Osama_bb11 · Answer

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

Matrix1000 · Answer

Thank you so much! It works great! I really really appreciate your help.

Need Formula for automatic date update in same cell

3 responses

Similar discussions

Subscribe To Our Newsletter!