Solved

Oct 8 of each year

Posted on 2014-09-24
5
151 Views
Last Modified: 2014-09-24
experts, what would be the formula to arrive at Oct 8 of each year?  It must be dynamic formula and not entered simply as Oct 8, 2014 and change for each year after that.  

thank you
0
Comment
Question by:pdvsa
  • 2
  • 2
5 Comments
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 40342838
Well, you can start with:
=DATE(2014,10,8)

if you wanted row 1 to be 2014 you could do row() + 2013 for the year . . . or some offset of that kind.

Not sure what you mean by dynamic other then the year has to change.
0
 

Author Comment

by:pdvsa
ID: 40342844
Kyle, thanks.  2014 is hard coded and I really need something dynamic.  Maybe Now()?
0
 

Author Comment

by:pdvsa
ID: 40342848
something like:
=DATE(NOw(),10,8))  but I dont think that is the answer
0
 
LVL 69

Accepted Solution

by:
Qlemo earned 500 total points
ID: 40342851
Do you want to get 8-Oct-(this year) for the whole year, or should be all dates after 8-Oct to be in next year?

The former is e.g.   = DATE(YEAR(Today()), 10, 8)
0
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 40342856
Olemo is correct . . . year(Today()) would get you the current year.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question