Thread: [Solved] Find Date Month
View Single Post
 
Old 07-22-2018, 05:54 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by macropod View Post
Charles' issue was with finding the month via its formatting, using VBA.
True! But unnecessarily complicated! Really his task was comparing dates on 2 sheets:
Was there a 1st of month in other sheet from same month as month of checked date?
Or (which option is right one remains unclear) was there a any date in other sheet with month same as month of checked date?

Using formats for it was only his way to do it! As result he got an issue :-)
Reply With Quote