TODAY() function - get a date value in a formula NOT DATE FORMATTED

[jae113]

Ok, so I would like to use the TODAY function in a cell that contains a formula, and even formating that cell as Date doesn't seem to work. So what I thought I would do, was have the TODAY function in another sheet, say Sheet2 C1, then somehow get the visible date, 7/15, in another cell, Sheet2 C2, and have my original formula display the date as 7/15.

Complicated? I hope that's understandable.

The problem I keep having is that the absolute value of TODAY is the serial number, not the date in date format. Is there a way to get TODAY, in date format, in my original formula?

Thanks!

 

[dcamos]

Do you want it in the formula to show something like 1/2/11 which would be done by using the text formula =text(c1,"m/d/yy")

 

[Rick Rothstein]

Wherever you are using TODAY() in your formula, trying using TEXT(TODAY(),"m/d") instead. The "m/d" part uses the same coding that you would use when Custom Formatting a cell containing a date, so you can adjust the way the date is presented in your formula to your liking.

 

[CWatts]

If I understand you correclty try enclising with the text formula:

=TEXT(your_formula,"m/d")

 

[jae113]

Wherever you are using TODAY() in your formula, trying using TEXT(TODAY(),"m/d") instead. The "m/d" part uses the same coding that you would use when Custom Formatting a cell containing a date, so you can adjust the way the date is presented in your formula to your liking.

AWESOME!!!!!!!! This is the one that did it! I'll have to remember that! I was going totally complicated and by using absolute value! Thank you so very much!

Thanks very much to everyone!