LinkBack URL
About LinkBacks
Try this formula in E3
=DATE(B1,1,8)-WEEKDAY(DATE(B1,1,7))
format as desired, e.g. for your example m/dd
or for a text result....
=TEXT(DATE(B1,1,8)-WEEKDAY(DATE(B1,1,7)),"m/dd")
Try this formula in E3
=DATE(B1,1,8)-WEEKDAY(DATE(B1,1,7))
format as desired, e.g. for your example m/dd
or for a text result....
=TEXT(DATE(B1,1,8)-WEEKDAY(DATE(B1,1,7)),"m/dd")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks