Formula to find Month and Day but excluding the year in a date

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to find Month and Day but excluding the year in a date

08-27-2022, 04:37 AM

Marcia

Windows 10 Formula to find Month and Day but excluding the year in a date

Office 2019

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Thank you Arvi. I had been doing the formula using the TEXT function hence I kept on getting erroneous answers.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting date, month & year from a text string without using date format Help	Haha88	Excel	5	08-06-2021 01:19 PM
Empty date cell shows wrong month & year	Learner7	Excel	3	06-16-2019 11:09 AM
Find Date Month	charlesdh	Excel Programming	11	07-24-2018 06:11 PM
Excel day date month year Function	greginky	Excel	1	01-05-2016 02:19 AM
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 03:20 AM.