I need to add an extra column with the quantity of days for each month in order to calculte the average amount of revenue for each rig.
Column "Date" is in date time format.
Any ideas?
Thanks!
Solved! Go to Solution.
You should be able to use the following formula.
datetimediff(DateTimeTrim([Date],'lastofmonth'),DateTimeTrim([Date],'firstofmonth'),'days')
*Edited. There was an error in the original formula. This one should now work.
There are multiple ways to do this
1- using find and replace
2- Formula tool
3- Others as well ( but did not want to complicate it.)
find and relpce will be very easy here.
Thanks a lot! it worked!
just added +1 at the end of the formula in order to get the correct quantity of days
Regards,
Seba
Thanks Raj, I check on this and also worked!