formula get specific date based on date of computer

abdelfattah

Well-known Member
Joined
May 3, 2019
Messages
1,429
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
hello
i need formula to specific date after calculate 12 months so i have date in column a and the result in column b so it a2 = 1/7/2019 and when add 12 months when date reaches before finish day it shows in b2 =1/7/2020 it supposes showing this date when date of computer becomes 30/06/2020 i would this formula is dynamic because i have many dates
input

1 .xlsm
ABCD
1CURRENT DAYA NEW DATE
201/07/2019
315/05/2018
410/01/2011
5
6
sheet3

output
1 .xlsm
ABCDE
1CURRENT DAYA NEW DATE
201/07/201901/07/2020
315/05/201815/05/2019
410/12/201110/12/2011
5
6
sheet3
 
no changes two formula don't work as you see
i put in c2,d2 the formula
2.JPG

3.JPG
 
Upvote 0

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
They both do work, since your computer date is February 7 while January 7 is now over. There is then little more to warn.
For future requests you might be more specific.
 
Upvote 0
hi, Fluff , GWteb i would adjust your formulas it show the date when reaches after 12 month for instance the date in b2=1/07/2019 when the date in computer=1/06/2020 then the same cell b2 =1/07/2020 it continues to 30 /06/2020 and hide after this date until to get into a new year so the condition shows the date from 1/06 to 30/06 every year
 
Upvote 0
Please tell us exactly what you want, rather than continually "moving the goal posts".
 
Upvote 0
sorry fluff about this what i'm looking for the writing date and the result show at same time in b2 the cell b2= 1/07/2019 and i would show result in b2= 1/07/2020 only when the date of computer from 1/06/2020 to 30/06/2020 you can say the show date(1/07/2020) in b2 continues for June month it means hiding the date before this date 1/06/2020 and after this date 30/06/2020
 
Upvote 0
As you want it based on today's date, lets use that as an example. What dates should be shown?
 
Upvote 0
As you want it based on today's date, lets use that as an example. What dates should be shown?
as what i said date it based what write in b2 if 1/07/2019 then showing date 1/07/2020 if 5/5/2019 so showing date 5/5/5020 and so on
 
Upvote 0
If you have all the days of 2019 in column A, based on today's date 26th May, what is the first & last date that should be displayed.
 
Upvote 0
The first picture is only for clarification and how to work out the equation as you see in column A, a specific date is set for a specific year and in column B another date is set for another year so that a full year is calculated and in the column days are determined for a month based on the date of the device and before the year is completed of month as a kind of The alert is in our case before we get to a date 26/05/2020 where it starts from 26/04/20 to 26/05/2020 it show this date 26/05/2020

but the result in b2 when the date of computer 1s 26/04, 27,04,28,04 to reaches 26/05/ automatically change in b2 = 26/05/2020 after this date and it is empty the b2 and begins from every a new year with same system



image 1 b2 is empty because no reaches date of computer 26/04/2020
1.JPG


image2 the b2 becomes 26/05/2020 because close a month before completing the year
2.JPG


the image3 b2 is empty because past month before completing the year 27/05/2020


3.JPG

image 4 date of computer see image 3
4.JPG


and it begins the same thing every new year
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top