Question

  • Creator
    Topic
  • #2150529

    MS Excel Date Conversion

    Locked

    by nyakovleva ·

    What is the formula might be in order to convert any Date to the 1st of the subsequent quarter following this Date?
    For example:
    2/5/2008 => 4/1/2008
    5/3/2008=> 7/1/2008
    8/2/2008=> 9/1/2008
    12/5/2008=>1/1/2009

    I need this to calculate the Effective Date based on the anniversary date after certain years in service.
    Thank you.
    Natalya

All Answers

Viewing 0 reply threads