Great article, need more like this, however...

  • I went through and tried all the formulas. The one for the last day of the month works well except if the previous month was February. But I also ran into another weird issue. The following formula did not work for me and I can't figure out why:

    =Format(Today,"M")

    Returned:

    March 05

    From everything I've researched it should return the month digit. Does anyone have any ideas on why I get todays date instead with month and day.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply