DATEADD not working

didijaba

didijaba

Well-known Member
Joined
Nov 26, 2006
Messages
511
HI, I have formula I want to use but it doesn't give me wanted day shift. Masure "Count Of Selected Calendar Days" shows correct amount of days, but when applied within formula it shifts days just for 1 day, not 15, for example). Please advice, thanks
Code: 
CashIn Previous Period = 

CALCULATE([CashIn],DATEADD('Calendar'[Date],[Count Of Selected Calendar Days]),DAY))
 
Last edited:

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

brendalpzm
  • Question
Gallery not filtering properly
Replies
0
Views
71
brendalpzm
brendalpzm
brendalpzm
  • Question
Power Apps formula in gallery to apply condition
Replies
4
Views
135
brendalpzm
brendalpzm
M
  • Solved
Calculating Same Day Last Week only works partially in Power BI
Replies
2
Views
177
muhammadahmad21
M
P
  • Question
DAX PIVOT: Projects Closure Date Field - Number of Days Change - between differing Forecast Versions
Replies
0
Views
94
phil134
P
M
  • Question
DATEADD 'dates must be contiguous' error referencing measure in SWITCH formula
Replies
0
Views
1K
Maccer
M

Forum statistics

Threads
1,215,046
Messages
6,122,855
Members
449,096
Latest member
Erald

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top