MS Excel Date Conversion

Question

Creator

Topic
August 1, 2008 at 10:47 am #2154201

MS Excel Date Conversion

Locked

by nyakovleva · about 14 years, 7 months ago

How to convert in Excel any Date to the 1st of subsequent quarter folloing this Date?
For example:
2/5/2008 => 4/1/2008
5/3/2007 => 7/1/2007
8/2/1999 => 10/1/1999
12/5/2008 => 1/1/2009

I need this to calculate the Effective Date of payment based on the anniversary date after certain Years in Service.
Thank you for help in advance.

Natalya

This conversation is currently closed to new comments.
Creator

Topic

All Answers

Author

Replies
- August 1, 2008 at 10:47 am #2922182
  
  Clarifications
  
  by nyakovleva · about 14 years, 7 months ago
  
  In reply to MS Excel Date Conversion
  
  Clarifications
- August 1, 2008 at 11:03 am #2922173
  
  Go here for tips and tricks of Excel
  
  by Anonymous · about 14 years, 7 months ago
  
  In reply to MS Excel Date Conversion
  
  http://www.exceltip.com/exceltips.php?view=category&ID=111
  
  Please post back if you have any more problems or questions.
Author

Replies

Viewing 1 reply thread

PURPOSE These guidelines from TechRepublic Premium will help you define the necessary ingredients of a security policy and assist in its proper construction. They’re designed to work hand in hand with the subjective knowledge you have of your company, environment and employees. Using this information, your business can establish new policies or elaborate on those ...

PURPOSE Recruiting an Artificial Intelligence Architect with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit from TechRepublic Premium provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY ...

PURPOSE Hiring the right Autonomous Systems Engineer requires a specific and precise recruitment process, supported by a thorough understanding of the project requirements. This Hiring Kit from TechRepublic Premium provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, ...

Software

Question

MS Excel Date Conversion

All Answers

Clarifications

Go here for tips and tricks of Excel

Guidelines for building security policies

Hiring kit: Artificial intelligence architect

Hiring kit: Autonomous systems engineer

Hiring kit: Application support engineer