The enrty cell, A1 contains a year number, e.g. 2007.
How do I calculate in another cell the Date of the last Tuesday in July of that year?
Thanks
Gabor
The enrty cell, A1 contains a year number, e.g. 2007.
How do I calculate in another cell the Date of the last Tuesday in July of that year?
Thanks
Gabor
use this formula
=DATE(A1,8,1)-WEEKDAY(DATE(A1,8,5))
Thanks, it's working fine.
Gabor
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks