pdvsa
asked on
25th of every month
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))
Regards
try this :
=WORKDAY(IF(DAY(TODAY())<= 25;DATE(YE AR(TODAY() );MONTH(TO DAY());25) ;DATE(IF(M ONTH(TODAY ())<12;YEA R(TODAY()) ;YEAR(TODA Y())+1);IF (MONTH(TOD AY())<12;M ONTH(TODAY ())+1;1);2 5));0)
(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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nice! Sorry for my tardy reply. I got a little sidetracked with my job. I don't like this job anymore
Open in new window