A date row which can subtract from a date column

I want to do something like this where I want to give weights to projects for particular month based on how far the release
date is . I dont think i can make a row a βdate rowβ. How can I achieve this?
Best Answer
-
Hi @dbalakk
You have to convert the 36 months to days (which in your case would be 1096) and put the weights in double quotes "value", this is how your formula would work -
Hope this helps,
Cheers!
Ipshita
Ipshita Mukherjee
Answers
-
Hi @dbalakk
You have to convert the 36 months to days (which in your case would be 1096) and put the weights in double quotes "value", this is how your formula would work -
Hope this helps,
Cheers!
Ipshita
Ipshita Mukherjee
-
Thank you so much! Yes it does
-
@dbalakk - I am glad it helps you, don't forget to hit the "Awesome" to my response if it helped you :)
Cheers!
Ipshita
Ipshita Mukherjee
Help Article Resources
Categories
Check out the Formula Handbook template!