Thx for your efforts ❤........Kya mobile mai aisa ho sakta hai ? Kyu (ctr +T) ya other format of excel show nhi hota to koi solution hai to bataoo jisse mai aisa format mobile se bna saku....
Nice day book with grt explanation but when I'm using sr no ,day & date column not working in table format need to drag manually, what I can do abt it ? Txx
Dear Jitendra, Your presentation is very nice. But I have to remind you one thing in your Auto Numbering formula for S. No. Suppose in case you have to delete entire row for S. No, 3 for some reason (e.g. S. No. 2 and 3 were the same entry and you want to delete S. No. 3). In such case your Auto S. No. Formula does not work. You will see S. No. 3 disappears and there exist S. No, 4. Similarly, if you select S. No. 3 then insert a row and enter the date, you will see all S. No. 3 is repeated twice (1, 2, 3, 3, 4, 5...) hence all other S. No. will be damaged. These two problems will be solved if you write the following formula at cell B11. =IF([@Day]="","",COUNT(D$11:D11))
Dear Arun, Yes, you are absolutely right. This is the problem in my sheet. I should have used COUNT function in place of ROW. I would like to say very much thanks for your brilliant suggestion. Now user can delete or incert rows without changing S. No.
Sir your project is very good I understand easily please sir can you tell if am any project make want the serial no and the date automatic come on dash board update automatic
Sir full process kr li bna lia pori sheet lekin last me date wise show nahi ho rahi h vlookup and if error bhi lgaya h lekin show hi nahi ho rahi h blank cell hi aa rha h help me out
Sir , you can make me inventory and taxation and accounting software GST add together and passwords system and add-on feature system .This software like Tally software.
Sir receipt aur payment me jo date aur day ka formula automatic kam nahi kar raha hai sirf jaha par formula laga hai vaha par hi kam karta hai niche nahi karta
UA-cam में बहुत विडियो दखते है पर आपका जैसा वीडियो कभी नही देखा पूरा समझ में आने हिसाब से कितने अच्छा से बोलते हो सर जी
Lot of thanks chhetri ji
Plz सर जी आप फोटोशॉप की बारे में भी कुछ वीडियो बनयांगे तो उसमे भी हमको कुछ सीखने को मिलेगा
Chalany sy, banana bhaut bada kaam h ji... aapki mehnat ko dhanybad...ji
Gurudev, Bahut hi shandar .aapne meri ichchha puri kar di .koti koti dhanyawaad aapko mera.
Thank you so much Ravindra ji
Please continue your blessings
SIR JI AAPKI VIDEOS DEKHI BAHUT ACHHE AUR BAHUT HI SARAL SAMJHAME AATAA HAI
Thanks
Bahut useful jankari di hai aapne sir ji, please aise hi aur videos dalte rahein, dhanyawad 🙏👍👍
Thanks Arvind ji
ua-cam.com/video/5l3HmDV63Xo/v-deo.html
Thank You Sir 🇮🇳🇮🇳🇮🇳
Thanks Shantilal ji
Thanks A Million Sir
Great Work
Thanks once again
I did all but not support to expand auto column when we entry payment and received sides.
Good👍👍👍👍👍
Thanks
ua-cam.com/video/5l3HmDV63Xo/v-deo.html
Great work
Thanks
Excellent teaching sir, 🙏🙏
Thanks Nagendra ji
Sir, if function is not working for auto numbering, can you please help me on this?
Great work sir, keep it up
Thanks Arshad bhai
good morning sir
very very thanks sir ji
Good Morning Prajapati ji
Kaise hai aap
Thx for your efforts ❤........Kya mobile mai aisa ho sakta hai ? Kyu (ctr +T) ya other format of excel show nhi hota to koi solution hai to bataoo jisse mai aisa format mobile se bna saku....
Dear sir instead of data we can use customer name in search by date.
Nice video
Sir iska 2 part h kya
Please reply
ua-cam.com/video/S2WDMXwD4-8/v-deo.html
Very nice
Thanks
Sir day book k liyea kon c format use hota like cash book ja receipt and payment
Nice day book with grt explanation but when I'm using sr no ,day & date column not working in table format need to drag manually, what I can do abt it ? Txx
Dear Jitendra,
Your presentation is very nice. But I have to remind you one thing in your Auto Numbering formula for S. No.
Suppose in case you have to delete entire row for S. No, 3 for some reason (e.g. S. No. 2 and 3 were the same entry and you want to delete S. No. 3). In such case your Auto S. No. Formula does not work. You will see S. No. 3 disappears and there exist S. No, 4. Similarly, if you select S. No. 3 then insert a row and enter the date, you will see all S. No. 3 is repeated twice (1, 2, 3, 3, 4, 5...) hence all other S. No. will be damaged. These two problems will be solved if you write the following formula at cell B11.
=IF([@Day]="","",COUNT(D$11:D11))
Dear Arun,
Yes, you are absolutely right. This is the problem in my sheet. I should have used COUNT function in place of ROW.
I would like to say very much thanks for your brilliant suggestion.
Now user can delete or incert rows without changing S. No.
Nyc.sir jii
Thanks
Thanks indeed
Welcome
Sir your project is very good I understand easily please sir can you tell if am any project make want the serial no and the date automatic come on dash board update automatic
Is search by month possible?
What about if there are 2 entries on same day.
Sir full process kr li bna lia pori sheet lekin last me date wise show nahi ho rahi h vlookup and if error bhi lgaya h lekin show hi nahi ho rahi h blank cell hi aa rha h help me out
👍🏻
Thanks Bro
ua-cam.com/video/5l3HmDV63Xo/v-deo.html
Iferror ki problem h kafi baar krke dekh liya day book me search by date me
Sir, please explain date wise debit and credit total in two columns and balance in next line.
SIR HOW CAN WE CHANGE FINANCIAL YEAR AFTER ENTRY OF 2020 - 2021 TO 2021 2022?
Create a copy and change dates
sir, i also would like to watch more advance Excel, basically dynamic Excel work.
Dear Bishwajit,
You are on a right place.
Please continue your support
Userform vba banake link kaise kare uska video banaye
Good morning and Happy New year sir,
How I can print and save my current invoice without vba ?
Datebook wale video ko Userform banake usako link kaise kare usape video banaye, sir
Sir daybook banane Ke bad file slow open hora hai kya karoon
Udaro mai deke saman ke kaisa record karee
Iske sath legar maintain kese kar sakte hy
Sir ji agar hum ak hi date me 10 party ko payment kr rhe h or 10 party se received kr rhe h to ak hi date me 10 entry krne pr search kaise kr skte h
Sir , you can make me inventory and taxation and accounting software GST add together and passwords system and add-on feature system .This software like Tally software.
Hello sir if u add search bar strt date to end date
Bilkul tally jaisa rahete acha rahena excell use karake cash book se ledger kaise karn o video banaye plz
Iferror formula work out hi nhi kr rha
Bro please make one video for Busess transport , how to maintain daily expenses and income + customers invoice + customers history
Sir receipt aur payment me jo date aur day ka formula automatic kam nahi kar raha hai sirf jaha par formula laga hai vaha par hi kam karta hai niche nahi karta
ua-cam.com/video/5l3HmDV63Xo/v-deo.html
Sir part 2
Mera filter Ni hat rhaa main Kia krun
Ese hi rahne dijiye koi problem nahi hai
@@PowerExbyJitendra mgr phr formula ni lgega na
Sir ,
My Day Formula is not working while I'm put correct again and again
Dear Aqeel please follow video carefully you will do it surely
@@PowerExbyJitendra sir put very carefully.. the show the Name! Value
Please sir make one project daily expense if enter expense its Sprat's
You may watch our video on DAY BOOK
I HAVE DOWNLOADED THE TEMPLATE BUT HOW I CAN PUT FORMULA TO ENTER DETAILS
Please follow the steps discussed in the video
Sir day formula kam nahi kar raha hi jesa ki aapne bataya..
Sir Maine formula correct dala hai phir BHI day wali cell main date aah Raha hai
Im facing same issue in my Excel 2007
I am also facing
Summary Formula Not working
Sir plz excell se ledger banadakte
PL CONTEL NO PAL
Hi sir Hamare Excel Me if.function Kam Nahi Kar Raha hai
Go to formulas tab, click on calculation options and click on automatic if it is on manual
@@PowerExbyJitendra Already Automatic Select sir
Aur sab excel function kaam kar rahe hai kya???
@@PowerExbyJitendra ji sir ji you are Great
@@PowerExbyJitendra sir Aap se 1 Request hai Company ka 1 month ka vait kaise nikale 1 video Banaye Sir ❤
Formula kaam Nahi Kar Raha kyu
Kaun sa formula hai Mukesh ji
Hi
Hello
Good speach
Thanks a lot
Super spsch
Thanks
Mera file format Ka border b Kam ni krha