Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(DAY(A1)>25,DATE(YEAR(A1),MONTH(A1),25),DATE(YEAR(A1),MONTH(A1)-1,25))
- =IF(DAY(A1)=25,A1,IF(DAY(A1)>25,DATE(YEAR(A1),MONTH(A1),25),DATE(YEAR(A1),MONTH(A1)-1,25)))
- =IF(OR(DAY(A98)=25,DAY(A98)>25),DATE(YEAR(A98),MONTH(A98),25),DATE(YEAR(A98),MONTH(A98)-1,25))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement