No, I need it to be right, Anyone have excel?

I read that this might do it but I don't have excel:

=DATE(YEAR(27/01/2011),FLOOR(MONTH(A1)-1,3)+1,1)

Posted By: Larry Hagman on December 10th 2012 at 14:46:52

Message Thread

Can someone please help me to calculate quarterly dates? (NCFC) - Larry Hagman, Dec 10, 14:39:54
- It's all in GL.GL_PERIODS (n/m) (NCFC) - NorfolkSteve, Dec 10, 16:40:49
- Its something to do with EOMONTH function. (NCFC) - tudders, Dec 10, 16:11:53
- Late contender for Thread Of The Year (n/m) (NCFC) - Huge Small, Dec 10, 16:00:22
  - lol (n/m) (NCFC) - Tricky Hawes, Dec 10, 16:07:47
- is this what you mean? (NCFC) - greybeard, Dec 10, 15:40:54
  - Nope, quarterly from 27/01/2011 (n/m) (NCFC) - Larry Hagman, Dec 10, 15:45:00
    - Am I missing something? All the months have more than 27 days, so you just change the mon (NCFC) - Arizona Bay, Dec 10, 15:47:17
- I'm not sure if I understand your question... (NCFC) - Vivid Data Shark, Dec 10, 15:26:05
  - Quarterly starting from 27/01/2011 (n/m) (NCFC) - Larry Hagman, Dec 10, 15:44:35
- There is a way of doing this, give me a minute. (n/m) (NCFC) - tudders, Dec 10, 15:07:32
  - Cheers! (n/m) (NCFC) - Larry Hagman, Dec 10, 15:09:29
    - Might be more like an hour, late for a meeting. (n/m) (NCFC) - tudders, Dec 10, 15:15:46
      - OK (n/m) (NCFC) - Larry Hagman, Dec 10, 15:22:34
- At a guess it would be 31 Mar, 30 Jun, 30 Sep, 31 Dec.... (n/m) (NCFC) - Vivid Data Shark, Dec 10, 14:51:41
  - I need em all to be right from 27/01/2011 (n/m) (NCFC) - Larry Hagman, Dec 10, 14:54:40
- just add 3 months at a time and approximate thae date, No one will notice. (NCFC) - Cheltenham_Canary, Dec 10, 14:41:47
  - No, I need it to be right, Anyone have excel? (NCFC) - Larry Hagman, Dec 10, 14:46:52
    - that won't do it.... (NCFC) - Pixelman, Dec 10, 14:49:21

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.