Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

Oct 8 of each year

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
pdvsa
Asked:
pdvsa
  • 2
  • 2
1 Solution
 
Kyle AbrahamsSenior .Net DeveloperCommented:
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
 
pdvsaProject financeAuthor Commented:
Kyle, thanks.  2014 is hard coded and I really need something dynamic.  Maybe Now()?
0
 
pdvsaProject financeAuthor Commented:
something like:
=DATE(NOw(),10,8))  but I dont think that is the answer
0
 
QlemoC++ DeveloperCommented:
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
 
Kyle AbrahamsSenior .Net DeveloperCommented:
Olemo is correct . . . year(Today()) would get you the current year.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now