Web Development

Ask something
Discussion Locked

Convert Date to Word

0 helpful
1 reply

by dpbaria

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to Convert Any date in to Word like
18/10/1975 ---- Eighteenth of October Ninteen Seventy Five
like that i want to use access or excel
help me urgently

dpbaria@yahoo.com

1 reply

by bfilmfan

This formula will return will return the date of Nth day-of-week for a given month and year. For example, it will return 26-March-98 for the 4th Thursday of March, 1998. Days-of-week range from 1 to 7, with Sunday = 1 and Saturday = 7.

=DATE(Yr,Mon,1+((Nth-(DoW>=WEEKDAY(DATE(Yr,Mon,1))))*7)+
(DoW-WEEKDAY(DATE(Yr,Mon,1))))

Where Yr, Mon, Nth, and DoW are cell references or values indicating Year, Month, Nth, and Day-Of-Week.

This discussion is closed to new replies.