Using =Today() to replace in place of a cell reference formula
https://community.smartsheet.com/discussion/comment/421684#Comment_421684
In regards to above linked question/answer from KPH 2/24/24 - 3rd to last Parr. mentions using today's date rather than a referenced cell. Can someone elaborate - If there is no cell reference where do is the today formula inserted into the overall formula. ie: if using Base Date cell reference is:
=ย DATE(YEAR([Base Date]@row), MONTH([Base Date]@row) + 1, 1) - 1)
change to current today's date? - where is the =Today inserted. below yields incorrect argument
=ย DATE(YEAR(=Today(), MONTH(=Today() + 1, 1) - 1)
Best Answers
-
I appear to be missing something - now I have:
=ย DATE(YEAR(TODAY()), MONTH(TODAY())ย + 1, 1) - 1)
Unparseable
-
The closing parenthesis at the very end also needs removed.
Answers
-
Just remove the = from before the TODAY() functions and make sure you have the appropriate parenthesis.
YEAR(=Today()
changes to
YEAR(TODAY())
MONTH(=Today()
changes to
MONT(TODAY())
-
I appear to be missing something - now I have:
=ย DATE(YEAR(TODAY()), MONTH(TODAY())ย + 1, 1) - 1)
Unparseable
-
The closing parenthesis at the very end also needs removed.
-
PERFECT - Thank you Paul!
Help Article Resources
Categories
Check out the Formula Handbook template!