3 Powerful & Essential DATE formulas for finance people

Chandoo, I have to say that not only are you very accomplished with excel, but your teaching methods are also spot on and your communication skills are second to none. You are able to communicate some complex formula data but very clearly and in simple terms. If only you were around 30 years ago.

Anna Please let me know how to give the Day along with date.

Thank You Sir.

Please make Accounting Video Playlist

Your way of presenting the lessons is more than wonderful. I give you my sincere thanks.

How to code to upper case and lower case in EXCEL CUSTOM FORMATING?

Can you prepare a lesson about CODING IN EXCEL CUSTOM FORMATING?

HI Chandoo, i am an auditor. Pls make a video on data grouping and data mapping on excel.

Kindly make videos on POWERBI

Thanks Sir 🙏

Hi Chandoo. Great date tips! Thanks for sharing :)) Thumbs up!!

Hi Chandoo, I have requested earlier to make a video on FTE Calculation and burndown chart

Hello Chandoo, please let me know if there is any mistake in the formula below?
="Q"&CHOOSE(MONTH(E4),2,2,2,3,3,3,4,4,4,1,1,1) - If I want the Q1 to be starting from April.
="Q"&CHOOSE(MONTH(E4),4,4,4,1,1,1,2,2,2,3,3,3) - If I want the Q1 to be starting from October.
Unfortunately I'm not getting the desired answer for the Q1 starting in April and Q1 starting in October.

Sometimes excel file directly goes into notify mode ...no change allowed automatically...we have to save d same file wid new name if data changes r to b saved

How to avoid this...how to make sure that our excel doesn't goes in auto notify mode

Thanks

A very practical and easy to follow (as usual) video! Chandoo, you are truly a master of Excel and a best teacher! Keep it up! 😊👍

So coool 😊😊

Hi, what email can I send you a business offer?

good relevant sponsor (Squarespace) too, Chandoo....cool stuff!

Sir please leave your email ID below
For some doubts to be cleared

These are cool functions Chandu... Thanks much for sharing knowledge

In India Q1 starts with April let me know how to calculate for this ?

Hai chandoo..
I have been facing an issue in the Fixing the date format in the particular cell range. if anyone enter the date in a different formats in a cell then i should turn into DD-MM-YYYY only..do u have any idea please.

Thanks from all accountant and financial mis

Making efficient database tables and creating storage location wise dashboard from MB51(SAP) dump for a sample of data.

Thank you so much.

I'm pretty sure that many people are getting benefitted from your sharing of knowledge such as this and becoming Awesome in their profession. No words to THANK YOU Chandoo.

Thanks for the video, specially for financial year formula.
Require video on getting opening balance for a particular month and then printing ledger for that month (where data is available for the full year and opening balance for the first day of the year)

Great.. Excellent.. Thank you so much..

Best

Thanks Chandoo.... You are making us AWESOME!

This is awesome!

Quick book

Superb

Great sir

Nice