Need Formula for automatic date update in same cell
Solved/Closed
Matrix1000
Posts
1
Registration date
Friday 30 May 2014
Status
Member
Last seen
30 May 2014
-
30 May 2014 à 15:51
Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014 - 13 Jun 2014 à 23:56
Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014 - 13 Jun 2014 à 23:56
Related:
- Need Formula for automatic date update in same cell
- Nvidia automatic driver update - Guide
- Logitech formula vibration feedback wheel - Download - Drivers
- Microsoft store update download - Download - App downloads
- Windows update blocker - Download - Other
- Kunoichi training latest update - Download - Adult games
3 responses
Osama_bb11
Posts
21
Registration date
Sunday 25 May 2014
Status
Member
Last seen
25 September 2014
1 Jun 2014 à 04:48
1 Jun 2014 à 04:48
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
=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
Posts
21
Registration date
Sunday 25 May 2014
Status
Member
Last seen
25 September 2014
9 Jun 2014 à 01:55
9 Jun 2014 à 01:55
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
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
Thank you so much! It works great! I really really appreciate your help.
Osama_bb11
Posts
21
Registration date
Sunday 25 May 2014
Status
Member
Last seen
25 September 2014
13 Jun 2014 à 23:56
13 Jun 2014 à 23:56
welcome any time
3 Jun 2014 à 13:42
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?