Web Development

General discussion


Convert Date to Word

By dpbaria ·
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


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to Convert Date to Word

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.


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

Related Discussions

Related Forums