+ Reply to Thread
Results 1 to 6 of 6

Dollar Symbol For Paycheck Every Other Thursday on Calendar

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    1,271

    Dollar Symbol For Paycheck Every Other Thursday on Calendar

    Hello,

    Is there a way to insert a dollar sign symbol on the Calendar every other Thursday like I did for January 4th. This is for paychecks that are biweekly.

    This can be with formulas or VBA.

    Thank you very much
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,657

    Re: Dollar Symbol For Paycheck Every Other Thursday on Calendar

    =IF(ISEVEN(WEEKNUM(L7)),"$","")
    Try this formula in the cell under the daynumber (L12, L18....)
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    1,271

    Re: Dollar Symbol For Paycheck Every Other Thursday on Calendar

    Thanks but there isn't a symbol from the formula.

  4. #4
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    1,271

    Re: Dollar Symbol For Paycheck Every Other Thursday on Calendar

    I created a sequence of dates for the year on the Events sheet.

    Will this maybe help fill the Calendar with the symbols?
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,657

    Re: Dollar Symbol For Paycheck Every Other Thursday on Calendar

    Is this what you want?
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    1,271

    Re: Dollar Symbol For Paycheck Every Other Thursday on Calendar

    Yes thank you very much @ popipipo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how do I change the dollar symbol to euro symbol
    By Arpita_Excel in forum Excel General
    Replies: 5
    Last Post: 07-20-2015, 02:26 AM
  2. Replies: 1
    Last Post: 07-13-2014, 09:37 AM
  3. Replies: 5
    Last Post: 03-04-2014, 10:01 AM
  4. Replies: 5
    Last Post: 01-08-2013, 11:38 AM
  5. the f4 key, dollar symbol
    By stevieob in forum Excel General
    Replies: 5
    Last Post: 02-02-2010, 11:37 AM
  6. Calendar Dates, Dollar Amounts and Assigning Points
    By avidcat in forum Excel General
    Replies: 1
    Last Post: 07-06-2009, 03:26 AM
  7. [SOLVED] How can I change dollar sybbol to euro symbol?
    By zwerver in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-31-2006, 03:00 PM

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