25th of every month
Experts,
How can I show the 25th of the month based on the current date and if the 25 of the month has passed then use the next month?
ie:
today = Oct 5
result: Oct 25
if today = Oct 26 then
result = Nov 25th
==>but if it falls on a Friday or Saturday then use the preceding.
thank you
How can I show the 25th of the month based on the current date and if the 25 of the month has passed then use the next month?
ie:
today = Oct 5
result: Oct 25
if today = Oct 26 then
result = Nov 25th
==>but if it falls on a Friday or Saturday then use the preceding.
thank you
Last Comment
you can also use this if you want to return a date value instead.
use the Number Format to format the date value accordingly.
=IF(DAY(TODAY()) <= 25, DATE(YEAR(TODAY()),MONTH(TODAY()), 25), DATE(YEAR(TODAY()),MONTH(TODAY())+1, 25))
use the Number Format to format the date value accordingly.
Hi,
pls try
pls try
=EOMONTH(DATE(YEAR(A1),MONTH(A1),DAY(A1)-25),0)+25-WEEKDAY(EOMONTH(DATE(YEAR(A1),MONTH(A1),DAY(A1)-25),0)+25)+MIN(5,WEEKDAY(EOMONTH(DATE(YEAR(A1),MONTH(A1),DAY(A1)-25),0)+25))
try this :
=WORKDAY(IF(DAY(TODAY())<=
(you might need to replace ; with , depending on your regional settings)
=WORKDAY(IF(DAY(TODAY())<=
(you might need to replace ; with , depending on your regional settings)
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Nice! Sorry for my tardy reply. I got a little sidetracked with my job. I don't like this job anymore
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Open in new window