krishnaa_kumarr88
New Member
- Joined
- Sep 30, 2014
- Messages
- 33
Hi Everyone,
Thanks for looking at my query.
My issue is as follows,
I created two seperate excel. One is for loading data(like attendance signup) and other is for dashboard with graph to indicate total number of present vs absent. I would like to create a bar graph on monthly basic.
My issue is i am using below formula in the dashboard which is working fine but it referesh once in a week automatically.
=COUNTIFS('Attendance'!A24:A22084,"ABSENT",'Attendance!B24:B22084,">="&TODAY()-WEEKDAY(TODAY(),3),Attendance'!B24:B22084,"<"&TODAY()-WEEKDAY(TODAY(),3)+7)
But i would like to get a formula which store monthly data so that i can show the graph for complete year.
Thanks a lot for your help.
cheers
Thanks for looking at my query.
My issue is as follows,
I created two seperate excel. One is for loading data(like attendance signup) and other is for dashboard with graph to indicate total number of present vs absent. I would like to create a bar graph on monthly basic.
My issue is i am using below formula in the dashboard which is working fine but it referesh once in a week automatically.
=COUNTIFS('Attendance'!A24:A22084,"ABSENT",'Attendance!B24:B22084,">="&TODAY()-WEEKDAY(TODAY(),3),Attendance'!B24:B22084,"<"&TODAY()-WEEKDAY(TODAY(),3)+7)
But i would like to get a formula which store monthly data so that i can show the graph for complete year.
Thanks a lot for your help.
cheers