Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Allen, Texas, USA
    Posts
    727
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Date to be displayed within a formula

    I am trying to display a date inside a formula. I know how to do the =TODAY() function, but if I put it within a formula that's bringing in other data it doesn't display correctly. Can this be done somehow?

    Thanks!

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    k2kz,

    Try the format Text(Today(),"mm/dd/yy") in your formula.

    Example:
    =IF(A2=1,CONCATENATE(TEXT(TODAY(),"mm/dd/yy"),A1),CONCATENATE(TEXT(TODAY()+1,"mm/dd/yy"),B1))

    dateval.png
    Last edited by Maudibe; 2014-03-27 at 19:44.

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Allen, Texas, USA
    Posts
    727
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Perfect. That did the trick! I was missing how to do that Text format formula. Thanks Maudibe!

Posting Permissions

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