Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2018, 03:58 AM
ArviLaanemets ArviLaanemets is offline Formula For Sorting In Order Date Wise Windows 8 Formula For Sorting In Order Date Wise Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default


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.
Attached Files
File Type: xlsx Birthdays.xlsx (17.5 KB, 10 views)
Reply With Quote
  #2  
Old 05-15-2018, 04:36 AM
suniltko suniltko is offline Formula For Sorting In Order Date Wise Windows 7 64bit Formula For Sorting In Order Date Wise Office 2010 64bit
Novice
Formula For Sorting In Order Date Wise
 
Join Date: Mar 2017
Location: Cochin, Kerala, India
Posts: 12
suniltko is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
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
Reply With Quote
Reply

Tags
sorting date wise

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula For Sorting In Order Date Wise 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft