Attach a sample workbook, please. Provide source data and a manual mock-up of what you want on the second sheet. 20-30 rows of sample data will be enough.
Posts by AliGW
-
-
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 well-known 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/get-w…dates-and-times
-
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 5-digit 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 cross-posting.
-
Cross-posted:
Help with IF formula with combination of OR & And
A formula with combination of And & ORMOD EDIT Cross-posted: https://www.excelforum.com/excel-formulas-and-functions/1411121-help-with-if-formula-with-combination-of-or-and-and.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.
-
-
Cross-posted 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 -
Please familiarise yourself with our rules, in particular:
Quote4b. Do not cross-post without supplying a link to the duplicate question on the other Forum.