Formula For Sorting In Order Date Wise

ArviLaanemets · #1 05-15-2018, 03:58 AM

Uploaded the workbook anew, as the formula for next birthday didn't calculate correctly for leap years (for BD on February 29). In new workbook the formula is corrected.

suniltko · #2 05-15-2018, 04:36 AM

Quote:

Originally Posted by ArviLaanemets

Uploaded the workbook anew, as the formula for next birthday didn't calculate correctly for leap years (for BD on February 29). In new workbook the formula is corrected.

Thank you for your reply. But it seems the final details are NOT updating automatically as per today's date. I need upcoming birthdays at top as I've shown in my original excel. Can you please share your thoughts.

Thank you,
Sunil Thoams

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to change alphabetical order in Word for sorting in a foreign language	BobK	Word Tables	1	12-01-2017 05:17 PM
Auto-filter horizontally column wise on basis of date	shoaib1989	Excel	0	02-18-2016 11:16 PM
Sorting in alphabetic order	Dimsok	Word VBA	5	09-10-2014 02:58 AM
How to fetch data from one sheet to another with complete details and date wise as well	harisjawed86	Excel Programming	1	08-05-2014 09:10 PM
Formula to count entries as per month, year and submission wise from different sheets	pinkacidpunk	Excel	1	05-28-2013 08:26 AM