Results 1 to 5 of 5

Date being replaced by text in monthly financial period but still acting as a date

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2024
    Location
    Ottawa, Canada
    MS-Off Ver
    MS365
    Posts
    20

    Date being replaced by text in monthly financial period but still acting as a date

    Hello,

    Quick question, hopefully this doesn't require VBA.

    In my spreadsheet attached, look at cell K5 (highlighted in yellow)
    Instead of entering the month, I'd like to be able to enter P1, P2 or whatever period up to P12 instead of the date BUT the calculations would still happen as if it was a date in K5. (even better if I can put it in a dropdown list)

    Mar-2024 represents P1
    Apr-2024 represents P2
    May-2024 represents P3 and so on
    .
    .
    Feb-2025 represents P12

    Thank you for your help.
    Pat
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date cell not acting right
    By Sliver5489 in forum Excel General
    Replies: 4
    Last Post: 01-25-2024, 05:24 AM
  2. [SOLVED] Convert Date to Financial period and year
    By Philangr8 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-29-2015, 02:06 PM
  3. Replies: 4
    Last Post: 06-12-2014, 11:37 AM
  4. [SOLVED] Semi Monthly autofill Period Starting Date based on Period Ending Date
    By greatwent in forum Excel General
    Replies: 6
    Last Post: 01-30-2014, 03:29 AM
  5. Replies: 0
    Last Post: 07-25-2013, 10:03 AM
  6. Replies: 2
    Last Post: 06-07-2013, 02:21 PM
  7. Replies: 1
    Last Post: 12-13-2010, 08:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1