rory Where has this been crossposted? I can't see a link anywhere.
Posts by AliGW


Attach a sample workbook, please. Provide source data and a manual mockup of what you want on the second sheet. 2030 rows of sample data will be enough.

If this has resolved your issue, you can click on the smiley face bottom right underneath my post and mark the thread as solved.

Your months are not dates, so Excel cannot compute this for you.
In A2:
01/09/2023
In B2 copied down:
=EDATE(A2,1)
Custom format: mmm
In B2:
=SUMIF(A2:A13,"<="&TODAY(),B2:B13)

Pecoflyrer
If it's a wellknown problem, and you know how to do it, please provide a solution.
If you do not wish to assist our members with EITHER specific links to specific help online OR a solution yourself, please refrain from posting.
You have made the forum seem unfriendly and unhelpful.
Papiya
Apologies for the unfriendly 'welcome'.
Please have a look at this tutorial, which should help you: https://exceljet.net/formulas/getw…datesandtimes

Please read this forum's rules, particularly regarding cross posting. Thanks.
ThreadForum Rules
THREAD TITLES
1a. Thread titles MUST aptly and concisely describe your problem.
1b. Your title must describe your problem, not your anticipated solution.
1c. Use terms suitable to a Google search and do not use words like "Please Help", "Urgent", "Excel Problem"
1d. Do not use Excel formulas in thread titles. E.g. "Help with VLOOKUP" (you have assumed the solution to your problem involves VLOOKUP).
Why? All of the above makes your code search engine friendly and easier for other people with…S OOctober 3, 2017 at 12:29 AM 


You were told why in the last lengthy thread on this issue on EF.
I believe it was TMS who explained to you in some detail that VBA works in US date format, therefore what in a UK locale would present as 08/07/2023 or 08 July 2023 will display in US format as 8/7/2023  in the US the standard format is m/d/yyyy.
If you look at the underlying 5digit serial number, it should be the same for all three dates.
Provide a workbook if you require fursther assistance.

Please read the forum rules regarding crossposting.

Crossposted:
Help with IF formula with combination of OR & And
A formula with combination of And & ORMOD EDIT Crossposted: https://www.excelforum.com/excelformulasandfunctions/1411121helpwithifformulawithcombinationoforandand.html I am trying to…forums.excelguru.ca 
Try:
=IF(OR(L5="",M4=""),"",SUM(L5,M4))
or:
=IF(OR(L5="",M4=""),"",L5+M4)

I'm not interested in being paid. OzGrid has got their 10%  it's fine by me.

In I6:
=INDEX($C$3:$F$9,MATCH(1,(ISNUMBER(SEARCH(I2,$A$3:$A$9)))*($B$3:$B$9=I3),0),MATCH(I4,$C$2:$F$2,0))

Explain what you are trying to achieve.

Try this:
=IF($Q31="","",IF(AND(TODAY()Q31>30,TODAY()Q31<89),"Yes","No"))

It isn't completely resolved on EF  the OP has, unsurprisingly, shifted the goalposts. The sample really isn't representative.


Crossposted on THREE other forums.
Please read our rules before posting here again: Forum Rules

Thread
Forum Rules
THREAD TITLES
1a. Thread titles MUST aptly and concisely describe your problem.
1b. Your title must describe your problem, not your anticipated solution.
1c. Use terms suitable to a Google search and do not use words like "Please Help", "Urgent", "Excel Problem"
1d. Do not use Excel formulas in thread titles. E.g. "Help with VLOOKUP" (you have assumed the solution to your problem involves VLOOKUP).
Why? All of the above makes your code search engine friendly and easier for other people with…S OOctober 3, 2017 at 12:29 AM