From DATE To DATE

[ozbeachbum]

I have a start day and date entered in F46 and I am looking to have a calculation in H46 that will show the END DAY and DATE in 12 months. (The day before the next start date which will be the Wednesday).
EG: F46 Wed 14- Sep-22 H46 Tue 12-Sep-23
Any assistance greatly appreciated.
Cheers,
Dave.

 

[PeteWright]

Not sure if it works on all dates, but give it a try:

Book1.xlsm
	F	G	H
46	Wed 14-Sep-22	>	Tue 12-Sep-23
Sheet30

Cell Formulas
Range	Formula
H46	H46	= F46 + 363

 

[MARK858]

Another option

Book1.xlsb
	F	G	H
46	Wednesday September 14, 2022	>	Tuesday September 12, 2023
Sheet3

Cell Formulas
Range	Formula
H46	H46	= EDATE(F46,12)-2

 

[Alex Blakenburg]

It depends a little bit on what you trying to do.
Anything that is based on a multiple of 7 is going to work ie 7*52 -1 = 363 Post #2
I don't believe using months (post #3) will work without adjusting what day of the week you land on since you won't always land on the same day of the week.

Weeks in a financial period can vary since it depends on where you land in relation to your Year-end date, eg roughly every 5 or 6 years you will need 53 weeks instead of 52 in a financial year. So if this is relevant to you we need to build in a test for that.

 

[ozbeachbum]

Thanks everyone.
Alex thanks for the explanation.

 

[Alex Blakenburg]

No worries. Glad we could help.