General discussion

Locked

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

dpbaria@yahoo.com

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| 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.

=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.

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums